AnsweredAssumed Answered

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

Question asked by njoyce on Oct 7, 2009
Latest reply on Oct 7, 2009 by philmodjunk

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!

Outcomes