Lookup Table

[no1tmorrow]

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, 2010 by Guest

[djlane]

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

[no1tmorrow]

Thank you so much.

djlane for Filemaker President...