Hi Listers - I have a table of Elementary Street Units (ESUs), essentially polylines, each with an ESU-ID, all comprising my STREETS table - This I inherited - I select ESUs from this table and save them to another table, RouteESU (created by me), along with a Route ID composite key, to store a bus route, copying the STREET obj to this so routes appear on the map. - I need to write a copy of my tables to Visual Foxpro-like tables (.dbf) when I've updated the Routes table above. Similarly, when a route is deleted in my VFP application, I need to delete the Route-ESU records pertaining to it Now somewhere along the line the Route-ESU table has lost its objects and, although I can browse the table and the records are there, I can't map them. I have 3 problems here: 1. How did the table lose its objects? 2. I want to reinstate the objects but I can't figure out HOW I did it in the first place. There is, and was, no X/Y, Eastings/northings etc. in it. When you go to the "Create Points" menu item it wants to know what columns to get the X and Y co-ords from; there's only the Route ID and ESU ID. 3. I looked to the "parent" STREETS table to see how that was geocoded and I can't see what THAT is based upon, there being no obvious x/y, E/N. Besides, I've never geocoded polylines so don't know how they get their x1/y1, x2/y2 and Centre x/y. Can someone help me with this please? Although I'm getting quite skilled now at programming in MB, it's the initial setting up/MI side of things that I'm green at. 'ppreciate it Terry McDonnell
