Trying to select employees from a roster

Question

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
------------------------------

MarkShnierYou · Answer

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
------------------------------

Sign up

Login to the community