Forum Discussion

MikeRorstad's avatar
Qrew Cadet
5 years ago

Help with table connections

I have a few tables that I'm having trouble connecting.

I have a job log table that has a job number and performance period information,

I have an employee table where all of the employees are listed,

From the job log, I have a link to select the employees assigned to the job and can enter the number of hours authorized.

After that is established, I have a link from the job log for a daily report.  I want to have that daily report include the employees that worked on that job and how many hours they individually spent on that job.

I want to have a running balance of hours remaining from the time authorization and I can't figure out how to make the relationships work to do the math.


1 Reply

  • DonLarson's avatar
    Qrew Commander

    What table holds the value for Time Authorization?

    Don Larson
    Westlake OH