I'm not sure if I'm in the right section but here's my dilemma:
I have two tables.. one that stores vendor costs [JobCosts] and one that stores employee hours [EmployeeHours] ... each feed a select query ([Extract_Labor] and [Extract_Other]) that filters out non-billable entries as well as calculates billing and pay rates .... and these two queries are joined in form a union query called [allcosts].
What I need to be able to do is use the value from from [allcosts].UniqueID to filter the source table so I can go to the original entry and edit it.
Here I am at the record in [allcosts]:
and here's where I want to be in the table where the data is stored...
or the form that feeds the table....
We're generally looking at this data after its been joined, so if something is incorrect or otherwise needs adjustment, I need a quick way to get to that source data instead of manually navigating and filtering.... any help would be much appreciated!