Table Questions

From: Steve (someone_at_somewhere.com)
Date: 03/12/04 

Date: Fri, 12 Mar 2004 11:25:35 -0800

I have a people table related to a application table. The person table is
also related to a lease table. I need to keep track of peoples addresses
when they submit an application, have a lease with me, or move on to other
addresses. Should I have a separate address table? I have the same
situation with phone numbers. Someone turns in an application and has a
phone number. Then when they move in or out they may have different phone
numbers. I'd like to keep track of all of them. If I had several addresses
for a person in the people table how would I know if one was for an
application or for after they moved out of our unit? Any suggestions. I'm
just begining. TIA
Steve

Relevant Pages