4 Replies Latest reply on Mar 20, 2015 7:19 PM by philmodjunk

    Need some relationship help

    mdphillips

      Title

      Need some relationship help

      Post

      I've been working on a solution for several weeks.  The solution tracks job certifications for team members and seems to be working as needed (thanks Phil!)  Now I need to add another entity - required training.  This is definitely a many to many relationship position and training.  So after creating a table for "Training" with all the available courses.  I created a new table to relate training to positions called "Required Courses".  Everything in that step of the process seems to work correctly.  I created a layout for Required Courses which allows you to see all of the classes for a given position.  Here's where I'm getting hung up.  I would like to setup a portal, preferably on the Team Members layout, that will show a list of all the required courses for the member's position(s).  I believe I need to have an additional table instance (which I know how to do) of Required Courses and relate it to Member Positions but I can't for the life of me see how to join them.  I've tried several different ways but am obviously doing something newbie stupid and missing a step.  Any words of wisdom from the veterans?

      Capture.JPG