Help with a Report
I have 2 tables.
1)Table 1. There is a field in this table called "status"
2)Table 2. This is a table used for reporting. I have a global field where I want to list the different statuses that appear in table 1, field status.
The field status in table 1 has about 10 different statuses.
I want a user to be able to go to the reports table and select a report based on multiple statuses.
If I have a drop down list with the different statuses user can only select one status.
I assume the best option would be to use a checkbox where user can select multiple statuses and then run the report based on this.
How would I do a search in Table 1, based on all the values user selected in the checkbox field? The values get saves as a list with a return character separating the values.
Or is there a better way of doing this?