Discussions

Expand all | Collapse all

Trying to select employees from a roster

  • 1.  Trying to select employees from a roster

    Posted 6 days ago
    I am trying to set up a table that allows me to assign employees to each job.

    I have a Job Log table that has about 20 fields that include things like customer name, category of work, program manager, etc.

    In each record, I have a button that creates a report record in another table and that is functioning fine.

    I would like to add employees to each job from an Employee Roster table but can't figure out how to make that work.

    I tried creating the Roster table and then create a table-to-table relationship but that isn't getting me what I want.

    Is there a trick to making something like this work?

    ------------------------------
    Michael michael.rorstad@ameebay.com
    ------------------------------


  • 2.  RE: Trying to select employees from a roster

    Posted 6 days ago
    This is a classic many to many relationship.  One Employee has many Roster Assignment, but also One Job has many Roster Assignments.

    So how we do this in Quick Base is to create that "middle table" called say Roster Assignments.  Try that and post back if you get stuck anywhere.

    Note that when you build the relationships, you will have a better experience if you set the field properties for Related Job to be the lookup field probably called Job Name, and similarly with the employees, if the Key field of the employee table is [Record ID#] set the field property for Related Employee to be the lookup field probably called Employee Name.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Trying to select employees from a roster

    Posted 5 days ago
    Thanks Mark, that helped and it works like a champ!

    ------------------------------
    Mike michael.rorstad@ameebay.com
    ------------------------------