AnsweredAssumed Answered

Help with a Report

Question asked by jakes on Oct 22, 2014
Latest reply on Oct 23, 2014 by philmodjunk


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?