Left Join 3 Tables

[Guest]

Hello all,

Using Access 2003 - I'm trying to create a "lists manager" that will allow
me to select (or create) an list that would bring up all my contacts with a
checkbox. Checking the box will add them to the list. (An example would be
"Christmas Cards '04"). How do I get this done?

In trying to do this I have three tables. "Clients", "ListsMaster", and
"ListsConnector".

"Clients" has the contact info. "ListsMaster" has the event info (ie.
Christmas Cards). "ListsConnector" has the checkbox and the foreign record
of the primary key for "Clients" and "ListsMaster" (which are both
autonumber).

My problem is that when I click on the yes/no checkbox, I can either get the
Clients.ID or the ListsMaster.ID to populate, but not both. How do I get
this done? I'm assuming I'm missing something in a left join statement, but
I can't figure out what.

Thanks for all your help.

Aaron G
Philadelphia, PA

 

[Guest]

I do not know where you have the "yes/no checkbox" but the way I would do
this is the have two main forms with datasheet subforms with ListBox.
Main form one Clients and subform ListsMaster.
Main form two ListsMaster and subform Clients.