Find a new set based on previous results?

[Steve G]

Hi all. Thanks for any help that you have to offer...

I have an inventory database with about 4500 records. Each record is one piece of hardware -- desktop, laptop, monitor, etc.

What I want to do is first search the database to show all current Dell laptops that are currently in use. This is easy enough and gives me about 80 records as a result. But what I want to do next is have the database show me what monitors are in use with those ~80 laptops which would give me a total of ~160 records.

I have no idea how to do this. Basically I need a way to tell FileMaker "show me all of the monitors in use by these 80 laptops" without actually entering 80 separate search queries.

How can this be done? Thanks.

[mz123]

Do you have a relationship set up between the computer and the monitors?

If so, you can use the Go To Related Record script step and select "Match All Records In Current FOund Set" instead of "Match Current Record Only"

Hope that helps!