I'd like to create charts based on selected listbox items & entered dates from a form.
The first graph works fine, but the second one isn't loading the correct data.
I think the problem is that the second table uses "ID" instead of "WorkerID" and the main form's record source
is based on a specific table.
I've tried to create relationships between tables tWorker,tReg and tAbsence, but it did not recognize WorkerID in tReg.
Is there a solution to this?