I am fairly new to Filmaker and I am working in Filemaker 10. i am trying to build a report that is dynamic in nature. My desire is to have a report that will filter based on a Status and based on Date range. (see form below) The relationship between the two data bases as as follows.
Selected status = Status
AND DatetoDate_start < Date Created
AND DatetoDate_end > Date Created
I have created a field Selected status in the parent table. This field is defined as a Check Box Set in the layout.
The layout is pullling from the table "Invoice" which is the child table.