how to setup for 2 addresses per person

B

Boze

This is my first project in Access so this is a very basic question.
I'm setting up a database on politicians in my state. Some will have 2
addresses..1 in our state and 1 in Wash DC. I'm not sure how to set the
tables up for this. Would I use Address1, City1, Phone1, etc for the state
info and a separate table with Address2, City2, Phone2 for the DC info?

Thanks for any help. I'd also be interested in any online tutorials if
anyone cares to recommend some.

Boze
 
Top