1 Reply Latest reply on Jan 3, 2012 10:36 AM by philmodjunk

    Populating a join table

    joe@infocore

      Title

      Populating a join table

      Post

      I am having a problem with many-to-many relationships.  I have built the recommended "join" table but am having a problem populating it as I add records on either side.  Here is the situation:

      I have an "Employee" table and each employee can have many skills which are recorded in an "Employee Skill" table.  These are entered in a portal on the Employee layout. 

      Each employee has multiple dates on which they are available which are recorded in a "Scheduled Days" table.  These dates are entered into another portal on the Employee layout.

      I need to be able to create a portal on another layout that displays all "Employee Skills" for artists who are available on a selected date.  To do this, I created a join table between the "Employee Skills" table and the "Scheduled Days" table.  I need to know how I can populate/update this join table as I add or modify an employee's skills or scheduled days.

      All suggestions or advice are most appreciated.

       

       

       

        • 1. Re: Populating a join table
          philmodjunk

          Seems like you need a relationship between employees and the table of dates available rather than the table of skills.

          Skills>-----Employees----<DaysAvailable>---MasterSchedule

          Employees::__pk_EmployeeID = Skills::_fk_EmployeeID
          Employees::__pk_EmployeeID = DaysAvailable::EmployeeID
          MasterSchedule::Date = DaysVailable::Date

          A Portal to skills placed on the MasterSchedule layout should list all skills from all employees that are available on that date.