4 Replies Latest reply on Oct 7, 2009 10:28 AM by philmodjunk

    how to include only certain information in a report based on information in another table

    njoyce

      Title

      how to include only certain information in a report based on information in another table

      Post

      Hi,

       I am running filemaker pro 10.0 on windows XP operating system.  I am having trouble figuring out how to run a script that will give me a report based on whether or not a certain box is checked in that table.  so, an example:

       

      I have a table with lots of studies we are working on. I have a report that provides a summary of all these studies organized by the principal investigator.  I also have a field called terminated, which is a check box and the user can check "yes" or "no".

       

      I only want to include the studies if they are not terminated (so, if "terminated does not equal yes").

       

      I'm not sure where in my script I would put this though...

       

      thanks!