Results 1 to 6 of 6
  1. #1
    NiJunge is offline Novice
    Windows 11 Access 2016
    Join Date
    Aug 2022
    Posts
    2

    Cross reference ??

    Hi I could not find an answer for this so sorry if it has already been answered.




    I want to have a database that relates persons to projects BUT both so that I can see what project a person is on as well as see what persons is on a project.

    What solutions do guys and girls propose for this ?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,820
    If a person can be on only one project, then have a field in Persons table for project ID.

    If you want to maintain history of project assignments, that would be a many-to-many relationship and requires at least 3 tables.
    Table of projects.
    Table of persons.
    Table that relates projects and persons.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    NiJunge is offline Novice
    Windows 11 Access 2016
    Join Date
    Aug 2022
    Posts
    2
    Yes it is a Many many situation and I will have a look thanks

  4. #4
    davegri's Avatar
    davegri is online now Excess Access
    Windows 11 Access 2019
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    For example of Many-to-Many table and form implementation see this:

    Many-To-Many, two ways to update Junction table, includes Not In List handling (accessforums.net)

  5. #5
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    You might get an idea of what you need if you look for "ms access project database template".
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  6. #6
    orange's Avatar
    orange is online now Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    As June suggested:
    3 tables with these relationships

    tblPeople---->tblPersonWorksOnProject<-----tblProject

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

Similar Threads

  1. cross-reference tables
    By Davide in forum Access
    Replies: 8
    Last Post: 01-20-2022, 05:31 PM
  2. Many to many cross reference table as a subform?
    By craigugoretz in forum Forms
    Replies: 2
    Last Post: 02-07-2015, 01:51 PM
  3. Replies: 4
    Last Post: 08-13-2012, 04:39 PM
  4. Cross reference
    By Anne in forum Access
    Replies: 9
    Last Post: 09-23-2011, 08:01 AM
  5. Replies: 1
    Last Post: 06-18-2011, 10:00 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