Results 1 to 2 of 2
  1. #1
    intern24 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Nov 2017
    Posts
    2

    Red face Trying to figure out how to create a contact relationship database

    Hello!
    Sorry if this is a bit rambley, it is a hard thing to explain
    I need some help trying to figure out how to relate tables a database. I am semi-new to access, so I just need some help where to go.
    I am creating a database that is full of two large contact lists.
    I need to create a form that I can send to people to fill out.
    This form is only being sent out to one of the contact lists (1) and it is about how they know the individuals on the other contact list (2).
    So I would like the form to have the name of the individual from contact list 2 and then 3 options of how the person on list 1 knows them. (friend, colleague, acquaintance)
    I have been able to sent up the form, but where I am having trouble is how to "save" the data from this form in a readable and manageable format.


    I need to be able to use this data day-to-day.

    Any and all advice is appreciated.
    Please help a access newbie

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    Parent form / child form.
    say the parent form is 1 person (tPerson table with PersonID key) and shows all detail of this person.

    the child form based on tContacts
    has the PersonID (long)
    and ContactID (long) which can be a person in the tPerson table. A self relating because everyone is a person.

    if you dont want self relating, then tContactPersons can be a table identical to the tPerson table in fields.
    but you still need the tContact table to show who knows who, except ContactID comes from tContactPersons table.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Outlook late binding to create a new contact
    By sdel_nevo in forum Programming
    Replies: 1
    Last Post: 11-09-2016, 10:15 AM
  2. Replies: 1
    Last Post: 07-04-2015, 10:43 AM
  3. Replies: 2
    Last Post: 03-29-2014, 02:56 PM
  4. Replies: 1
    Last Post: 11-20-2012, 01:29 PM
  5. Need to create a subform, can't figure out
    By mattmurdock in forum Forms
    Replies: 2
    Last Post: 06-19-2012, 08:50 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums