AnsweredAssumed Answered

Relationships

Question asked by milky on Dec 6, 2008
Latest reply on Dec 7, 2008 by Jens Teich

Title

Relationships

Post

Hi,

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.

 

Outcomes