Hi Martin Thanks very much for the reply. I tried:
Select Rte_No, Gen, Directn, esu_id, elem_unit_id from RouteESUMap, streets where streets.elem_unit_id = RouteESUMap.esu_id into busroutes_map Map From busroutes_map I think that's as near as I can get to your example. But all I got was a non-mappable cursor, practically identical to the original RouteESUMap, with no graphics. Am I missing something here, or have you any other ideas. Yours gratefully Terry -----Original Message----- From: Martin A Spiers [mailto:[EMAIL PROTECTED] Sent: 30 August 2005 16:45 To: Terry McDonnell Subject: Re: MI-L How to geocode table with no obvious x/y I'm not sue you need the x/y coordinates of the bus route segments. If table "busroutes.tab" is as described and table "streets.tab" contains a graphical object for each ESU then these can be linked by the ESU then something like Select busroutes.bus_route_id, streets.esu_id from streets, busroutes where streets.esu_id=busroutes.esu_id into busroutes_map Map From busroutes_map will produce a new, mappable table with the same fields as the original "busroutes.tab" and the graphics from streets.tab Hope this helps --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 17680
