Here is a way thru: 1. If you have coordinates in your table goto 6. First we need to update coulmns with the coordinates from the origin and the destination. Start by creating 4 new float columns: ORIGX, ORIGY, DESTX, DESTY. You can either create these inside Access or save the table as a new MapInfo table and add the to this new table.
2. Now we have to geocode the origin location against the table with origins. 3. When this is done the ORIG columns should be updated with the respective coordinates. You should replace SHIPMENT with the correct name of the table. In the MapBasic window enter the following, each line should be followed by a hit on the ENTER button: Set CoordSys Table SHIPMENT Update SHIPMENT Set ORIGX = CentroidX(OBJ), ORIGY = CentroidY(OBJ) 4. Now we have to geocode the destination location against the table with destinations. 5. When this is done the DEST columns should be updated with the respective coordinates. You should replace SHIPMENT with the correct name of the table. In the MapBasic window enter the following, each line should be followed by a hit on the ENTER button: Set CoordSys Table SHIPMENT Update SHIPMENT Set DESTX = CentroidX(OBJ), DESTY = CentroidY(OBJ) 6. And now to the final step: Use the MapBasic window to do this: Set CoordSys Table SHIPMENT Update SHIPMENT Set OBJ = CreateLine(ORIGX, ORIGY, DESTX, DESTY) HTH, Peter Horsboll Moller GIS Developer COWI A/S Rugardsvej 55 DK 5000 Odense C Tel +45 6313 5013 Direct +45 6313 5008 Mobil +45 2270 4308 Fax +45 6313 5090 -----Original Message----- From: Tonya Logan To: '[EMAIL PROTECTED]' Sent: 21-01-03 17:37 Subject: MI-L MIPro - Beginner Points to Lines with MSAccess Sorry if this is a very elementary question, I've just begun using MI Pro, and I need some help. I have a MSAccess database with shipment history information. Is it possible to geocode the origin and destination points within the same table, and have MI Pro show directional lines from the origin points to the dests? Thanks! --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 5070
