display child field on parent record

Question

Parent Field: VendorContains vendor addressChild: Zip code, longitude, latitudeI need the the parent table to bring in the latitude and longitude related to the vendor address.&nbsp;&nbsp;I have created one to many and reversed.&nbsp; Have done everything I know to do including reading other discussions but I must be missing something.------------------------------Sarah Burres------------------------------

megcuddihee1 · Answer

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&nbsp;

zip&nbsp;has many&nbsp;Vendor (Address)&nbsp;Do not accept the "Related Zip" has the joining field - that will make a new field.&nbsp; 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------------------------------

sarahburres · Answer

Zip is the key in the zip code table.&nbsp; Record Id is still key in Vendor table.&nbsp; Since it is an address, that wont be the key field.&nbsp; I made a vendor zip code - text formula that was equal to the zip code field of the address. For the relationship, I only have the option of related zip.------------------------------Sarah Burres------------------------------

markshnier__you · Answer

What field type is Zip in the Zip table and is it the same field type as the formula zip in the Vendor table? They need to be the same field type to make a relationship.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

sarahburres · Answer

Worked great.&nbsp; Such an easy solution.&nbsp; I knew I was missing something like that.&nbsp; Thank you!------------------------------Sarah Burres------------------------------

Forum Discussion

display child field on parent record

Related Content

Many parent records on a single child record

Totaling Child Records Live on Parent Form

Display Thumbnail Image

Add child record through parent form and redirect back to parent form in edit mode

Pipeline to add Parent record from child import