I have a report based on a form, with some criteria to create which are quite complicated.
Basically the criteria for the report need to be:
select * from FORM_A
where value of FORM_A.FIELD1
in (array/collection of values of FORM_B.FIELD2 from FORM_B [FIELD4 >= '1974-01-01'])
Which means, for each record in the FORM_A, if the value of FORM_A.FIELD1 is contained in the collection of values from the selected records from FORM_B.FIELD2, then display the FORM_A record in the report. Is this something that can be implemented?