Parent Field: Vendor
Contains vendor address
Child: Zip code, longitude, latitude
I need the the parent table to bring in the latitude and longitude related to the vendor address.
I have created one to many and reversed. Have done everything I know to do including reading other discussions but I must be missing something.
------------------------------
Sarah Burres
------------------------------
Question
display child field on parent record
+6This topic has been closed for replies.
If in the Zip table you make the zip code the key field you can lookup the long and lat very simply.
Careful if you have already working relationships with the Zip - Record ID.
You want a relationship in which
------------------------------
Meg Cuddihee
------------------------------
Careful if you have already working relationships with the Zip - Record ID.
You want a relationship in which
zip has many Vendor (Address)
Do not accept the "Related Zip" has the joining field - that will make a new field.
Instead use the drop-down to select the existing zip field from the Vendor Table.
On the next screen you will be able to pick lat and long as lookup fields
Do not accept the "Related Zip" has the joining field - that will make a new field.
Instead use the drop-down to select the existing zip field from the Vendor Table.
On the next screen you will be able to pick lat and long as lookup fields
------------------------------
Meg Cuddihee
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.