Results 1 to 1 of 1
  1. #1
    Boost is offline Advanced Beginner
    Windows 8 Access 2013 64bit
    Join Date
    May 2018
    Posts
    47

    Relationship Design

    Hi there - I've been attempting to correctly structure my table relationships.

    The current way my db works is thus:

    tbl_personnel contains imported data through a link with SAP. This db is deleted and re-appended on open/close of the db to ensure realtime and current data.

    tbl_civilianskills contains the PK of personnel_SAP#, which is appended from tbl_Personnel. (this is so that the data recorded against a name doesn't get deleted when tbl_personnel is refreshed).

    tbl_Registrations_personnel, tbl_Qualifications_Titles, tbl_Skills_Personnel, and tbl_Languages_Personnel are combinations of the recorded skills + the particalar PK of personnel_SAP# for a record.



    I want these tables to all be linked back to the original tbl_Personnel via the PK of personnel_SAP#.

    This is in order to produce queries on values from tbl_Personnel as well as from select values from any other table (registrations, languages, qualifications, skills etc).

    I have attached an image in order to somewhat support my textual breakdown above. I hope that someone understands the gist of what I am trying to achieve, but if not i shall provide more detail and information behind what I am trying to achieve.

    Cheers

    Boost

    Click image for larger version. 

Name:	Capture.JPG 
Views:	24 
Size:	125.9 KB 
ID:	34925
    Last edited by Boost; 07-30-2018 at 07:49 PM. Reason: Addition of supporting Image

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

Similar Threads

  1. Relationship/Design Help
    By twc1001 in forum Database Design
    Replies: 1
    Last Post: 07-05-2013, 08:23 AM
  2. Relationship / Overall Design Question
    By nunzii in forum Database Design
    Replies: 2
    Last Post: 04-24-2013, 04:08 PM
  3. Table and Relationship Design
    By GrayWolf in forum Access
    Replies: 6
    Last Post: 01-31-2012, 02:04 PM
  4. Relationship Design
    By krymer in forum Database Design
    Replies: 3
    Last Post: 11-28-2008, 09:09 PM
  5. design using relationship...
    By dsnyder in forum Database Design
    Replies: 2
    Last Post: 10-21-2008, 12:00 PM

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
  •  
Other Forums: Microsoft Office Forums