cool. i'll likely be looking at this in more depth next week if i get time. i've got about 7000 bus stops and over 1000 routes (including stupid variations), 99% of it is linked and done, but i'm not happy with the quality of the data and want to re-do it before my project becomes too big and in the public eye.
i'll have more questions then, then. -----Original Message----- From: Terry McDonnell [mailto:[EMAIL PROTECTED] Sent: Wednesday, 28 July 2004 6:20 PM To: [EMAIL PROTECTED] Subject: MI-L RE: Ashley Simmonds - MI-L Selecting Bus Stops in Stopping order Ashley, Yes it was solved and with not too much difficulty. One possible difference from your scenario, though, is that my stops already exist as a map layer, which I bring to the fore, and, as the user clicks on each, it's recorded in a temp. cursor, with a global running order (incremented with each stop clicked on). When saved, the stop IDs, their ORDER, and the composite key of the parent Route are stored in the m-to-m link table (as any stop can appear in any route, and vice-versa). So I don't know if my stuff would be of any use to you but I'm happy to share any of it with you. Let me know Terry -----Original Message----- From: Simmonds, Ashley (DTUP) [mailto:[EMAIL PROTECTED] Sent: 28 July 2004 03:26 To: [EMAIL PROTECTED]; '[EMAIL PROTECTED]' Subject: RE: MI-L Selecting Bus Stops in Stopping order was any reasonably easy to implement resolution to this ever done? prior to now, i've had my system setup so that it just dumps all of the user's selected bus stops into a route description, and then it's left up to the user to sort them. however, if i'm able to do this with a clicking order, that would be far better. the option i'm likely to embark on is a manual process whereby the user selects a stop, then clicks a button on a form to put the selected stop into a buffer, then at the end of the process those stops will be added to the route. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12771 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12788
