Let’s say that I have two tables, Address and City. I have three fields in Address, AID, Address 1, and City. AID is the primary key, Address 1 is a plain varchar text field that the user types into on my form and City is a drop down selection where the user selects the city information from a drop down list provided by the City table. In the City table there are two fields, the CID field which is the primary key and the City field that holds all of the City names. When you are in the Address form and select a City from the drop down selection list the system stores the CID primary key information in the City field of the Address table instead of the City field information from the City table, which is quite normal.
When I create a Google Maps link and select the Address 1 and City fields from the Address table to locate the information on Google Maps the data it sees is Address, CID instead of Address, City. Short of removing the CID field and using the City field as the primary key, how do I get the Google Maps link to look at Address 1, and then the City field from my City table that corresponds to the CID stored in the Address table?
