David Ball
Registered User.
- Local time
- Today, 20:40
- Joined
- Aug 9, 2010
- Messages
- 230
Hi,
What is the best way to represent Country, State and City? Should there be individual tables for each of these three fields? Or should there be one table that contains all these fields? (with the values coming from an individual table for each field?)
I would then want to use these fields, Country, State and City, in another table, tblContacts.
I would also want to have a form, frmContacts, where a user could select/ build an address from combo boxes. And the combo boxes would need to filter based on the value selected in the previous combo, (only show US states if USA is selected in country, etc). Can this be done if the fields are not in the same table?
To further complicate things I need a button next to each combo box on the form where the user can open a form an add new values (add a new Country, State and/or City).
I am after an overview of the best way of representing the Country, State and City fields before starting as I can see it getting quite confusing and very time consuming if I begin the wrong way.
Thanks very much
Dave
What is the best way to represent Country, State and City? Should there be individual tables for each of these three fields? Or should there be one table that contains all these fields? (with the values coming from an individual table for each field?)
I would then want to use these fields, Country, State and City, in another table, tblContacts.
I would also want to have a form, frmContacts, where a user could select/ build an address from combo boxes. And the combo boxes would need to filter based on the value selected in the previous combo, (only show US states if USA is selected in country, etc). Can this be done if the fields are not in the same table?
To further complicate things I need a button next to each combo box on the form where the user can open a form an add new values (add a new Country, State and/or City).
I am after an overview of the best way of representing the Country, State and City fields before starting as I can see it getting quite confusing and very time consuming if I begin the wrong way.
Thanks very much
Dave