MikeRorstad
5 years agoQrew Cadet
Trying to select employees from a roster
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
------------------------------
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
------------------------------