1 Reply Latest reply on Dec 7, 2008 4:17 AM by Jens Teich

    Relationships

    milky

      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.

       

        • 1. Re: Relationships
          Jens Teich
             > I have 8 tables (one for each state) with PostcodeID, Postcode, Suburb.

          This is a mistake. These information belongs in the same table with an additional field 'state'.

          Then you need a relationship connecting state::state and city::state which is used to produce a value list with only the cities of the selected state.

          Jens