Table Structure Question ?

[Dave Elliott]

Is it better to use a single table and have one of the fields (for the form)
lookup via a combo a state for example or;
use a query for the form and then link both tables together so that the
state can be looked up this way?
One table for the form or two tables using a query?

Thanks,

 

[Douglas J. Steele]

To me, the answer is "it depends". What's the point of the form? Only to
show the information, or to allow people to change it? If they can change
the information, using one table and a combo box would seem to make the most
sense. If they can only see it, using the two tables in a query should be
sufficient.