It's me again!!! Tried the next step of the time clock progression, that is employee's clocking out. Trying to "filter" the Clock out list to only that particular Employee's Clock In's (in case there are multiple clock in's that never got clocked out.
The structure is
main tables =
"Time Clock Clock Ins"
""Time Clock Clock Ins Extended"
"Copy of Time Clock Clock Outs"
(Copied my first attempt that still works but doesn't filter, I'll change name later)
My query design has
Field = "Employee Name"
Table = "Employees Extended"
Field = "Time Clock Clock Ins.*"
Table = "Time Clock Clock Ins"
Based upon my reading of what boag suggested yesterday (Cascading reference reading) I have done the following (see pdf's attached) (hope they attach, pray they attach, don't know if they'll attach)
Am I missing something or is there a better way to do this??
Thanks in advance as always.....