If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Simple Design Question...I think
I have a people table and company table. Each person and each company can
have multiple telephone numbers. With respect to a telephone table(s), should I have two tables, a people telephone table and a company telephone table; or one table and have a 'Type' field to distinguish if its a people number of a company number? One point is that I do need to keep the order of the telephone numbers so there is a notion of a primary number and secondary number...etc. One query I will be needing is to pull only the primary number (if there is one) from the telephone table in a Join with the people (or company) table. It worries me how the Type field will be used with this type of Join. Thanks for any input JJBJr |
#2
|
|||
|
|||
Take a look at:
People in households and companies at: http://members.iinet.net.au/~allenbrowne/AppHuman.html The article suggests placing the individuals and companies into one Client table, even though you may want to use different forms to interface them. That solves the problem of telephone numbers and lots of other related data. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "JJBJR" wrote in message ... I have a people table and company table. Each person and each company can have multiple telephone numbers. With respect to a telephone table(s), should I have two tables, a people telephone table and a company telephone table; or one table and have a 'Type' field to distinguish if its a people number of a company number? One point is that I do need to keep the order of the telephone numbers so there is a notion of a primary number and secondary number...etc. One query I will be needing is to pull only the primary number (if there is one) from the telephone table in a Join with the people (or company) table. It worries me how the Type field will be used with this type of Join. Thanks for any input JJBJr |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Simple question: How to get web query to NOT overwrite data when it refreshes? | A Smith | General Discussion | 3 | September 6th, 2004 06:55 AM |
Simple stupid question | Jose Esteves | New Users | 7 | September 3rd, 2004 04:58 PM |
DB design question | Beringer | General Discussion | 8 | September 1st, 2004 06:19 AM |
Simple question? | Stranger | Using Forms | 1 | August 27th, 2004 02:59 AM |
Simple Query Question | Rebecca | Running & Setting Up Queries | 1 | June 3rd, 2004 10:59 AM |