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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to setup for 2 addresses per person 4
Increment field by 1 on insert Query 2
extracting info from an address block 10
Auto fill fields 3
parse return string into table, separate records 1
?? Some kind of look up function - Help and Thanks A Lot! 2
Selecting data from cells that are 5 rows apart and groung in 1 co 6
training database - required training per employee 3

Top