Results 1 to 3 of 3
  1. #1
    Carrinmere is offline Novice
    Windows 10 Office 365
    Join Date
    Feb 2021
    Posts
    15

    Help with Design / Relationships

    So I am constructing a database for my military squadron that handles quite a few aspects of day to day operations. One area that I am struggling with is designing a section for a persons Deployment Folder. For those unfamiliar, a deployment folder is unique to each individual and contains all the required training an individual has to be able to deploy. Some of the training is regional specific, so what is good for the Middle East may not be needed for the Pacific or South America. As of right now I have two tables designed. One is just for Deployment Requirements. It contains things like the Requirement Name, what region it is needed for, how often you have to accomplish the task and what part of the folder it sits in. The second table is based on the individual. When the database is utilized, a person should be able to assign a training requirement to an individual and put in the date when it was accomplished. With this data I can run queries to determine whether or not a person has all the requirements necessary to go to a certain region. The issue I am running into is being sure not to create duplicate entries by mistake while also being able to update the Deployment Requirements table with future training that may come down from higher headquarters. I set the Index to Yes (No duplicates) but then it only lets me put in one Deployment Requirement per individual as opposed to the 40+ some I already have established.



    Also the primary key for each table is ID Autonumber. It has to be this way because the back end is going on sharepoint which only recognizes ID Autonumber for primary keys.

    Also the third table in the Pic is the central table that I use as the PK. It contains all the Personnel Info for each person in the unit (Name, Rank, SSN, Physical Fitness Test Dates, Performance Report Date, etc.)

    Also I am new at Access and have been learning via Youtube so I am not overly familiar with terms. If you see a better way to construct I am all ears




    Click image for larger version. 

Name:	DB.png 
Views:	25 
Size:	101.8 KB 
ID:	46093


    -Carrinmere
    Attached Thumbnails Attached Thumbnails DB.jpg  

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Link for tbl_MobilityFolder and tbl_MobilityRequirements does not involve a PK. Why not?

    Where is table that has individual associated with mobility?

    If you want to provide db for analysis, follow instructions at bottom of my post.
    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
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi
    You will find that you cannot use Sharepoint tables to deal with Related tables.
    Tables in sharepoint only deal with specific lists.
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

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

Similar Threads

  1. Which relationships to use in my design?
    By mbenton in forum Database Design
    Replies: 11
    Last Post: 07-18-2016, 03:51 PM
  2. help with database design and relationships
    By Jen0dorf in forum Access
    Replies: 8
    Last Post: 08-26-2015, 11:57 AM
  3. Help getting design right first time (relationships)
    By Creakyknees in forum Database Design
    Replies: 4
    Last Post: 12-26-2013, 03:47 PM
  4. Design/Relationships
    By j9070749 in forum Database Design
    Replies: 2
    Last Post: 11-06-2013, 10:28 AM
  5. Help with table and relationships design
    By blinton in forum Access
    Replies: 1
    Last Post: 04-25-2012, 07:51 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