I don't know what to call what I want to accomplish so my searching isn't working.

I have

job -> check out sheet - > check out sheet line items.

Not every job has a checkout sheet.

So what I am trying to do is have a layout that I can show all the jobs that have checkout sheet but don't want to show any job that doesn't have anything at all. So if I have 5 jobs that have checkout sheets and 4950 jobs that don't I don't want to have to scroll through them all to find the 5.

Then on the 5 remaining I want to see every line item that was checked out (I am assuming some kind of portal for that)

In the non-Filemaker world I would just create a lookup table that would narrow my results to the 5 records and base everything on that.

Any ideas?

Thanks again

Thom

Edited January 14, 201016 yr by Guest

Thom,

See attached. This does what you need. It uses a calculation to count the number of related sheets. A find script finds the jobs that have 1 or more sheets. The only problem with this is that since the count is a calculation (ie not indexed), the Find might get slow with many thousands of records. If that happens, you can always create an indexed Numeric field, and run a script to set the value in that field from the value of the calculation. Then you base your find on the indexed numeric field.

Jobs.zip

Thank you so much.

djlane for Filemaker President...