I have a FM7 database with the following relationship

             1      *
Student -|----< Action Item

A field in action item can be in any of these four states:
Done
Waived
N/A
Not Done

I'm looking for a way to get a result set of any students with any
action item set to not done.

For some reason when I enter find mode and chose "not done" in the
action item portal I get a list of students who have any action items
at all regardless of the setting.

I'm wondering if a summery field, a script or a calculated field is
needed here.

Thanks in advance,

Russ

I just realized something,  I thought I was getting students with any
action items.  What is happening is there are some related action items
not displayed in this layout.  So let me restate my question:

I'm looking for a way to get a result set of any students who's first 7
action items are set to "Not Done"

Each of the seven have data that identifies them so I have a way to
tell them from the others.

Is this even posible?

kosherpiggy@hotmail.com wrote:

> I just realized something,  I thought I was getting students with any
> action items.  What is happening is there are some related action
> items not displayed in this layout.  So let me restate my question:
> 
> I'm looking for a way to get a result set of any students who's first
> 7 action items are set to "Not Done"
> 
> Each of the seven have data that identifies them so I have a way to
> tell them from the others.
> 
> Is this even posible?

Create a calc field that contains a specific value if any of the items
is not done.

If ( isEmpty (data1) or isEmpty (data2) etc ; 1 ; 0 )

Then do a relationship to match the 1, perhaps to a global set to 1.
Make both the student name and that completion match the criteria for
the relationship.

Matt

--