Hi, I was wondering if someone could help me with this problem. I have had a look through the forum but no luck with my request.

Let me explain what I have.

1 - Timesheet Application

1.1 - Timesheet Form (records hours users have spent on job.

Example:

123 Test Job | Jack | 3 Hours

123 Test Job | Tom | 4 Hours

345 Another Job | Jack | 2 Hours

345 Another Job | Tom | 1.5 Hours

1.2 - Timesheet Report (Shows jobs and the total amount of hours spent on this job by different users)

Example:

123 Test Job | 7 Hours

345 Another Job | 3.5 Hours

2 - Admin's Application

2.1 - Job Quote Sheet Form (In here I have the job name and then quoted job hours)

2.2 - Job Quote Sheet Report (In here I list out the jobs and their quoted hours)

Example:

123 Test Job | 9 Hours

345 Another Job | 3 Hours

What I would like to be able to do is have a report that clearly shows the total hours my employees have spent on a job, and next to that the quoted hours as per the example below:

123 Test Job | 9 Hours (Quoted) | 7 Hours (Current Time Spent) | 2 Hours (Remaining Time)

345 Another Job | 3 Hours (Quoted) | 3.5 Hours (Current Time Spent) | -0.5 Hours (Remaining Time)

I have managed to get as far as making a function to fetch the job name from the Admin Application and load this into the Timesheet application however this next step is causing me a bit of difficulty.

If anyone can explain how I can do this I would be really appreciative! We are finding that we are going over hours on quite a few jobs so it would be great to keep a eye on this in real time!

Thank you.