I am creating a correspondene database. The problem I am having is I have two tables:
1. Contacts
2. Correspondence
The correspondence table has 5 columns:
CorrepondenceID
Date:
To:
From:
Description:
Both the To: and From: colums lookup information on the Contacts Table. So when I use a listbox to display a Query of the the 10 most recent entries results of Correspondence Table, I can not link both the To: and From: to the Contacts table so I end up with the ContactID in one of the columns, either the to: or From: columns, since I can not link both.
Typical Result
CorrespoID Date To From Description
0234 10/12/2007 17 Bob Smith Called to say shipment late
where the "17" should be William Jones.
Any Ideas for better constructing the databse, so the query works in a listbox.
Thanks
Joe
1. Contacts
2. Correspondence
The correspondence table has 5 columns:
CorrepondenceID
Date:
To:
From:
Description:
Both the To: and From: colums lookup information on the Contacts Table. So when I use a listbox to display a Query of the the 10 most recent entries results of Correspondence Table, I can not link both the To: and From: to the Contacts table so I end up with the ContactID in one of the columns, either the to: or From: columns, since I can not link both.
Typical Result
CorrespoID Date To From Description
0234 10/12/2007 17 Bob Smith Called to say shipment late
where the "17" should be William Jones.
Any Ideas for better constructing the databse, so the query works in a listbox.
Thanks
Joe