Forum Discussion

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago

Re: Trying to select employees from a roster

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

2 Replies

Sort By
  • MikeRorstad's avatar
    MikeRorstad
    Qrew Cadet
    5 years ago
    Thanks Mark, that helped and it works like a champ!

    ------------------------------
    Mike michael.rorstad@ameebay.com
    ------------------------------
    • MikeRorstad's avatar
      MikeRorstad
      Qrew Cadet
      5 years ago
      Good morning,
      I'm hoping to get some more help on the same project.

      Here is what I'm trying to accomplish:
      I have a job log that has an entry that has specifics like Job ID #, title, the period of performance, etc.

      From that job log record, I have a URL button that allows employees to be added from our company roster and authorize the number of regular hours and overtime hours for that particular job.

      Once the time authorization is published and the job is underway, we have a requirement for the project manager to report what happened during the day and who worked that day and how many hours.

      I've been able to create the relationships between the job log, time authorization & employees and the daily report and the employees, which displays the Hours Authorized information and the Hours Worked information, but I'm having problems getting the running balance to be calculated on the daily report or back in the job log.


      ​

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