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