Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Find a new set based on previous results?

  •
Steve G
in Finding & Searching

Featured Replies

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.

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!

Create an account or sign in to comment
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Account

Navigation

Search

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.