AnsweredAssumed Answered

Mulligan on Relationships Help Question

Question asked by mdphillips on Feb 17, 2015
Latest reply on Feb 20, 2015 by mdphillips

Title

Mulligan on Relationships Help Question

Post

First off - many thanks to Phil for trying to help me out with this before.  Either I'm a complete idiot (very possible) or I didn't represent the project very well so I thought I would try it again since I think the relationships are a bit more complex that I originally anticipated.

The project needs, goals or whatever they are called are as follows:

The group has many members that need to be tracked for position certification
The group has 19 different positions available
Each member can become certified for more than 1 position
Each position has a task book and a Job Action Sheet (JAS) associated with it
Each member will have their task book(s) evaluated several times before becoming certified
Each member also receives 1 JAS for each position(s) every time they perform it

I added fields for every pk/fk combo I could think of even though I might not need them (newbie overkill) so don't laugh.  I also included a picture of what I would like to use as the main data entry layout.  Members could be added and then the related data could be added/seen via the portal.  Any insight would be greatly appreciated.

 

 

Tables.JPG

Outcomes