Results 1 to 2 of 2

MS Access 2016 (365) Trouble with establishing many to many Relationships I only get 1 many to many

  1. #1
    DocSmokey is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2019

    MS Access 2016 (365) Trouble with establishing many to many Relationships I only get 1 many to many

    In the attached document control application I am trying to build a document control register. this program will be used to track documents used in my business. I also want to control versions and keep records of changes made to documents, and track the implementation of the most up to date versions by staff members.

    I have attached Print screens of the Relationship Diagrams that I have built so far to illustrate my problem. As you can see in the diagram I have a documents file, and a comments file that I believe should form two many to many relationships. among others that are attached for departments, sections,and document types.

    My thinking is that I can have many documents that can undergo many changes hence the many to many relationships.
    Attached Files Attached Files

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Ottawa, Ontario, Canada; West Palm Beach FL
    A few comments based on a very quick look.
    --Access works best with names that do not contain embedded spaces nor special characters. I'd remove the "#" in your field names -- they will eventually cause syntax issues.
    --Relationships are based on "business facts", they are not arbitrary lines between tables.
    --I recommend you start with a clear description of your intended project in simple, plain English. Then working with pencil and paper, and some sample data and scenarios, create a model and work that model with your sample data and scenarios.
    --Do not be too quick to jump into physical database. This often leads to trial and error -analysis, design, test and refactoring -which can be quite slow and frustrating. Much easier to get a design on paper that you can vet and adjust which results in a blueprint for your tables and relationships.
    --There are free data models at Barry Williams' site - here's a link to a Document Management model. The model is a starting point showing typical set up --you can adjust as you see fit to meet our needs or just get some insight to adjust what you have currently.

    Seems Adobe Illustrator software is needed to open your relationship files? How about just using jpg or png?

    Good luck with your project.

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

Similar Threads

  1. Trouble with table relationships
    By barrensb in forum Database Design
    Replies: 3
    Last Post: 05-28-2019, 06:21 PM
  2. Having trouble creating relationships.
    By qwerty in forum Access
    Replies: 19
    Last Post: 10-29-2018, 12:49 PM
  3. Replies: 3
    Last Post: 10-10-2017, 08:09 AM
  4. Replies: 1
    Last Post: 03-23-2014, 11:27 PM
  5. Access Tables establishing PK and RI
    By Spanky2012 in forum Access
    Replies: 1
    Last Post: 11-08-2012, 02:53 AM

Tags for this Thread

Posting Permissions

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