Hi, Dominic Thanks for the reply. I've been struggling to send my code snippet but it keeps getting bounced back as too large. I think I've managed to get the formatting tags out of it now.
The trouble with your proposal is that I'm selecting stops on the map, one by one. I know you can select into a table but I can't predict what stops the user will want - I'm relying on the clicking on the stop symbols on the map. So, maybe I'm being thick, but I can't see how your suggestion can help me. Am I right? Thanks again Terry -----Original Message----- From: Dominic Lowe [mailto:[EMAIL PROTECTED] Sent: 15 June 2004 11:58 To: [EMAIL PROTECTED] Subject: RE: MI-L Selecting Bus Stops in Stopping order Hi Terry, Not having seen your code, so this is a guess, but you can SELECT INTO a new table. eg. "Select * From MYBusstops where Stop_no = 10 INTO MYSELECTIONTABLE" Then you can get the stop number (10 in this case) from MYSELECTIONTABLE.Stop_no If you always use the same table name it will overwrite the old table each time instead of creating query1, query2 etc. Hope that helps, Dominic --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12200
