Joined: 04 Apr 2013
Location: United States
Online Status: Offline
Posts: 5
Topic: Linking tables Posted: 04 Jun 2014 at 4:34am
I have 2 address data tables. The master file has columns with coordinates and the secondary address table does not. Is there any way to link the two so i can use the map coordinates in the primary table with the identical addresses in the second table?
Joined: 04 Apr 2013
Location: United States
Online Status: Offline
Posts: 5
Posted: 05 Jun 2014 at 4:58am
Yes, there is a address column with every address in my city in the master table, and an address column with identical data in the persons data table. I need it to look at an address column in the "persons" address column, go find the identical address in the master address column and bring in the coordinates for that address.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Posted: 05 Jun 2014 at 5:13am
if that is the 'overlapping' column, I would link the 2 mapping tables together based on that, this hopefully is a 1 to 1 mapping so that data doesn't duplicate or is excluded.
then you could just use the info from whichever table has it and display it on the report.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
