AnsweredAssumed Answered

How to fill multiple fields based off one field?

Question asked by g4guitar on Dec 19, 2015
Latest reply on Dec 19, 2015 by g4guitar

I have a table called ’Suburbs’ with 4 fields. Suburb, State, Zipcode & Country.  I have another table called Contacts. On the Contacts layout I want to be able to choose the suburb via a value list based on the Suburbs table/suburb field and for the other 3 fields from the Suburbs table to appear on the Contacts layout automatically.

For example if I choose say Hollywood I want California, 90046 and the US to appear in the other 3 fields. How would I do this?

Thank you.