A
Aaron
I have a design problem. I need to link talbes together to get a
desired result. I have a table with states another with cities, one
with zipcodes, one with counties one with boros, one with townships.
What I need to do is form relationships between them, 1st to reduce
redundancy and 2nd to create a form for selection. I want it to filter
on the form. example: type in a zip and have the state, city, fill in
automatically and leave a short list of boros or townships to choose
from. because the same zip might cover more than one boro or township.
I will eventually need to connect these to many other talbes. example
for a purchasers address in a purchases table. a suppliers address in a
supliers table, etc.. Is this possible, or is there a more effective way
to do this? I would appreciate any advice on this matter. by the way I
am fairly new at this, but I can understand most termonology.
desired result. I have a table with states another with cities, one
with zipcodes, one with counties one with boros, one with townships.
What I need to do is form relationships between them, 1st to reduce
redundancy and 2nd to create a form for selection. I want it to filter
on the form. example: type in a zip and have the state, city, fill in
automatically and leave a short list of boros or townships to choose
from. because the same zip might cover more than one boro or township.
I will eventually need to connect these to many other talbes. example
for a purchasers address in a purchases table. a suppliers address in a
supliers table, etc.. Is this possible, or is there a more effective way
to do this? I would appreciate any advice on this matter. by the way I
am fairly new at this, but I can understand most termonology.