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
|
|||
|
|||
In Access How do I link contacts (i.e spouses) in the same table
I am trying to create a contact database where both the primary contact and
the spouse can both be clients. They need to be listed as separate contacts since they can both own products, but I also need to link to each other. I prefer to do this in the same table but I worry about this creating two listings for each HUSBAND/WIFE and WIFE/HUSBAND combination. |
#2
|
|||
|
|||
In Access How do I link contacts (i.e spouses) in the same table
off the cuff - one way would be to create a new field "CoupleID" and for such
couples supply a unique ID that they share. -- NTC "Bill Adkins" wrote: I am trying to create a contact database where both the primary contact and the spouse can both be clients. They need to be listed as separate contacts since they can both own products, but I also need to link to each other. I prefer to do this in the same table but I worry about this creating two listings for each HUSBAND/WIFE and WIFE/HUSBAND combination. |
#3
|
|||
|
|||
In Access How do I link contacts (i.e spouses) in the same table
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Query is not updatable - | Doug Johnson via AccessMonster.com | Running & Setting Up Queries | 3 | January 21st, 2006 12:36 AM |
Can't refresh Access Link to SQL table through ODBC | Redstone | Using Forms | 0 | November 27th, 2005 08:09 AM |
How to delete duplicate contacts folders in Office XP? | Robert O'Connell | Contacts | 18 | October 6th, 2005 11:43 PM |
Access 2000 -vs- Access 2003? | Mark | General Discussion | 5 | November 30th, 2004 06:36 AM |
Access XP Compared to Access 2003 | Mardene Leahu | New Users | 1 | October 1st, 2004 05:11 AM |