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

    How to fill multiple fields based off one field?

    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.