4 Replies Latest reply on Dec 19, 2015 9:48 PM by g4guitar

    How to fill multiple fields based off one field?


      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.