Is there a way to conditionally put items on a report? Let's say that I ask a person 5 questions and the responses are Yes, No and Maybe. I want to print a report that has the items which were NO.

Table 1 -- ID, item1, item2, item3, item4, item5

Table 2 -- item_number, descriptive_text

Something like

if Table_1::item1 = N then

print Table_2::descriptive_text

where Table_2::item_number = 1;

if Table_1::item2 = N then

print Table_2::descriptive_text

where Table_2::item_number = 2;

if Table_1::item3 = N..." you get the point.

I can't find any scripting that will accomplish this. Can someone lead me in the right direction, even if it's just pointing to another thread that has already addressed this?

I'm using v7 on WindowsXP.

Thanks

ECS

Couldn't you create a table with a layout specifically for printing out your report? Create a field in this table that will always be "NO" and use this field as the relationship field to the tables containing the information you want on your report. You could make the "NO" field a drop down menu as well and select between "YES', "NO' and "MAYBE" depending on what report you want.

Unless there's more to this, I don't think you need an involved script.

Phil

As a newbie, I'm not sure how to implement this suggestion. What does the new table look like? I'm used to being able to use SQL which would quickly do this.

Thanks

ECS

I work with FMP 6 on a Mac, so I might not be the best person to explain this for you, but . . .

Create a table to layout your report then create a field that will always be "NO"

Create a relationship between Table1 and your layout Table between Table1::Item1 and your "NO" field and a relationship between Table1::Item2 and your "NO" field, etc.

You create relationships in File/Define/Database and the Relationship tab in 7

Then place portals into your layout Table, one based on each relationship, to display the "descriptive text" results of the relationship.

Phil