Hello Gabriel,
Many thanks for this excellent software!
Following with the first question made by BoreGodofBlunder I have a similar situation
with a particular requirement:
- same relation "employees"
- other relation (in my case "working_hours") linked with "employees", which holds the type of hours made by each employee every day (normal hours, extra, night, etc.).
The "working_hours" table has "date", "employee_Id" and all the type of hours as attributes.
"date" and "employee_Id" should be unique in this table.
I could make the form and the application runs without problems. You enter a date, choose the employee from the dropdown list and fill in the number of hours for each category. That's OK.
As we have to enter the hours for "all" employees for "each" worked day, a big help for the user in charge of enter the info would be if the dropdown list were filtered showing only the employees without records for the date considered.
I see you can filter the employees list by different criteria but I could not set the filter "employees which have no records in woking_hours table for the date specified"
The queston is: can I sove this graphically or do I need a sub query?
Thanks again!