Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

List(s) of Contacts

Discussion in 'Information Technology' started by Build or Die, Nov 3, 2005.

Tags:
  1. Build or Die

    Build or Die
    Expand Collapse
    Guest

    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.
     
  2. Loading...

    Similar Threads Forum Date
    Gurdwara contacts in West Yorkshire? New to Sikhism Oct 18, 2010

  3. Ron Hinds

    Ron Hinds
    Expand Collapse
    Guest

    "Build or Die" <BuildorDie@discussions.microsoft.com> wrote in message
    news:F61D7207-A3D6-4766-999B-FB9E5ED4BDD3@microsoft.com...
    > 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.


    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
     
  4. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    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.

    "Build or Die" wrote:

    > 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.
     
  5. Build or Die

    Build or Die
    Expand Collapse
    Guest

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

    "Ron Hinds" wrote:

    > "Build or Die" <BuildorDie@discussions.microsoft.com> wrote in message
    > news:F61D7207-A3D6-4766-999B-FB9E5ED4BDD3@microsoft.com...
    > > 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.

    >
    > 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
    >
    >
    >
    >
     
  6. Build or Die

    Build or Die
    Expand Collapse
    Guest

    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,

    "KARL DEWEY" wrote:

    > 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.
    >
    > "Build or Die" wrote:
    >
    > > 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.
     

Share This Page