List(s) of Contacts

B

Build or Die

I have a current database with a table of contacts. I would like to be able
to create a form that allows me to select certain contacts and that selection
would generate a list. The problem that I'm having is trying to set up the
ability to 'save' or 'log' that particular selection so I can come back to it
(add or remove names) -and- to complicate it a little more, I'd like to be
able to 'save' or 'log' multiple lists. I could place a checkbox in each
contact for each list, but then anytime I want to create another list, I
would have to add another checkbox. Is there another way to do this?
Thanks.
 
R

Ron Hinds

Build or Die said:
I have a current database with a table of contacts. I would like to be able
to create a form that allows me to select certain contacts and that selection
would generate a list. The problem that I'm having is trying to set up the
ability to 'save' or 'log' that particular selection so I can come back to it
(add or remove names) -and- to complicate it a little more, I'd like to be
able to 'save' or 'log' multiple lists. I could place a checkbox in each
contact for each list, but then anytime I want to create another list, I
would have to add another checkbox. Is there another way to do this?
Thanks.
Click to expand...

Create a new table "Lists" with a field for ListName and a field for
ContactName. With data it might look like:

ListName ContactName
------------- -------------------
Buyers John Smith
Buyers Tom Jones
Buyers Lisa Wood
Sellers Jill Eden
Sellers Jack Hill
 
K

KARL DEWEY

Yes. You can use three tables.
Table1 is the contacts with a primary key of ContactID - autonumber.
Table2 is a listing of your groups (list of list) with a primary key of
GroupID - autonumber.
Table3 is a union table with fields for ContactID and GroupID. Both of the
fields are number - integer.
Set the relations as one-to-many from Table1 to Table3 and from Table2 to
Table3.

The main form for contact has a subform - datasheet view - and combobox or
listbox the select group.
A second main form is just the opposite with groups and sub as contacts.
 
B

Build or Die

Makes sense... I'll try it out.... thanks alot

Ron Hinds said:
Create a new table "Lists" with a field for ListName and a field for
ContactName. With data it might look like:

ListName ContactName
------------- -------------------
Buyers John Smith
Buyers Tom Jones
Buyers Lisa Wood
Sellers Jill Eden
Sellers Jack Hill
Click to expand...
 
B

Build or Die

I have the tables setup and now I'm onto the forms. I know there are several
ways to display & create a series of mailing lists and I think this will be
one of the harder ones.

The goal is to display a full contact list that will have checkmarks (or
toggle) next to each name and a way to filter down to just the 'checked' ones
- all with the ability to change between lists.

So far I've got this:
I have a single form with two continuous subforms on it. The single form
has a combo box that you can select which list you'd like to view/edit. One
of the continuous forms displays the filtered contact list (based on the
linked table). The other continuous form displays the master contact list
(based on the full contacts table).

I think I need to place an unbound control on the Master Contact List that
would toggle the specific contact being included in the filtered list
(depending on what list is selected).

The trouble I'm having is setting the control source for the unbound toggle
because the listing first needs to be added to the linked table, and then all
I need to do is toggle that checkmark.

Is it my control source or do I need to build a better query for the Master
Contact List?

Thanks,
 
Top