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

    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 offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    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: 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
    Yes it is a Many many situation and I will have a look thanks

  4. #4
    davegri's Avatar
    davegri is offline Excess Access
    Windows 11 Access 2019
    Join Date
    May 2012
    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 (

  5. #5
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Ontario, Canada
    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 offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Ottawa, Ontario, Canada; West Palm Beach FL
    As June suggested:
    3 tables with these relationships


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