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?