I am trying to do the following:
I have a feild called States, set as a value list with states in Australia. (there are 8) I have 8 tables (one for each state) with PostcodeID, Postcode, Suburb.
What I am trying to do is when the user selects a particular state in the State feild, I only want the Suburbs for that State showing in the Suburb feild, and once the user tabs out of suburb, I want the postcode automatically entered in the Postcode feild.
Any help would be appreciated.