Hello... I have two tables and one pre-defined query: WO_tbl, WO_Task_tbl and Labor_qry. My current join of WO_Task_tbl to Labor_qry is working correctly. I have "all from WO_task and only those from Labor that match.." I am currently selecting (parameter criteria) from the WO_Task for Area, Type, Finished_date, then pulling in respective costs. -- this all works.
Now I find I need to also select by Parameter prompt for WO.Priority a given WO has one priority, but several tasks are part of the WO, and each date has it's own Finished Date. So I have a one to many from WO to WO_task.
I need only records with specific Finished Date from WO_Task while also prompting for specific (or ALL) Priorities stored in the WO table. Hope this makes sense, is this possible? thanks!!
Now I find I need to also select by Parameter prompt for WO.Priority a given WO has one priority, but several tasks are part of the WO, and each date has it's own Finished Date. So I have a one to many from WO to WO_task.
I need only records with specific Finished Date from WO_Task while also prompting for specific (or ALL) Priorities stored in the WO table. Hope this makes sense, is this possible? thanks!!
