Re: Table Questions

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Roger Carlson (NO-carlsoro-SPAM_at_hotmail.com)
Date: 03/12/04 

Date: Fri, 12 Mar 2004 15:11:31 -0500

If a person can have multiple addresses (even over time), and you want to
keep track of them, then yes, you need another table. The same is true for
phone number, although some people will advocate having a general "Numbers"
table in which you store phone, alternate phone, cell, email, fax, etc. You
have one field for the foreign key (of course), a field for the type of
number (phone, email, etc) and then a field to store the actual number. 

-- 
--Roger Carlson
  www.rogersaccesslibrary.com
  Reply to: Roger dot Carlson at Spectrum-Health dot Org
"Steve" <someone@somewhere.com> wrote in message
news:ucZ3LfGCEHA.1604@TK2MSFTNGP11.phx.gbl...
> 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

  • Re: Query from more than one table
    ... Steve, ... then created my query and that all worked great.... ... Their lease expiration dates are ... > If you change the target and max, then you need a date of change field or the ...
    (microsoft.public.access.queries)
  • Re: If I switch to static IP
    ... I tried switching to static IP and it was a mess. ... >the router I could not reestablish connection to it. ... during the lease period -- they'll renew the lease before it expires. ... Steve Winograd, MS-MVP ...
    (microsoft.public.windowsxp.network_web)
  • Re: DHCP IP and PC name info - if not good new group plz redirect me (sorry !!!)
    ... According to the follwing information try using the 1 option for the command ... IP address, subnet mask, unique ID, lease ... > Hi Steve, ... >> tell you the current lease IP to computer name info. Netsh can probably ...
    (microsoft.public.windows.server.security)
  • Re: !Re: Need help designing db
    ... Roger dot Carlson at Spectrum-Health dot Org ... "Steve" wrote in message ... like their spreadsheet so the users don't go into shock that they are ... guidance/suggestions on how to create an inventory tracking database. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: IIF statements
    ... Bibi ... "Steve Schapel" wrote: ... > lease which starts at a futrure date? ... >> today is YES and rent income is zero. ...
    (microsoft.public.access.queries)