how to include only certain information in a report based on information in another table
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...