Skip to main content
Question

display child field on parent record

  • October 1, 2019
  • 0 replies
  • 13 views
Forum|alt.badge.img+6
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
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img
  • MegCuddihee1
  • Registered
  • October 1, 2019
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 
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


------------------------------
Meg Cuddihee
------------------------------
Terms & ConditionsAccessibility statement