Mike,
What table holds the value for Time Authorization?
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Original Message:
Sent: 01-17-2020 16:07
From: Michael michael.rorstad@ameebay.com
Subject: 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.
------------------------------
Mike michael.rorstad@ameebay.com
------------------------------