AnsweredAssumed Answered

Dynamic Relationships

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

Title

Dynamic Relationships

Post

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.

 

Screen_shot_2012-08-15_at_2.48.06_PM.png

Outcomes