AnsweredAssumed Answered

Dynamic Relationships

Question asked by DuaneT on Aug 15, 2012
Latest reply on Aug 16, 2012 by DuaneT


Dynamic Relationships


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.