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.

Filter table results via relationship? Question...

Featured Replies

I have a table that contains tree types of data. Let just say TYPE A B C.... I wan to create a layout that shows just type A's Just type B's or Just type C's.

Now I can do this by creating a script, using Goto layer and preform a find for each of the types, and this works, but what I am looking for is a way to just return type A's without preforming a find?

So if someone uses the cmd J 'find all command' it still returns only they type they were on. It seems that I should be able to do this with some type of relationship but I am not sure where to start....

oh on a side note:

I have type A,B,and C in the same table because they are linked to a list table where I can have any number of A,B or C types in a list.

Typically, solutions developers don't allow users to access the standard menu set in FileMaker. Either they program all the functionality into buttons or they use Custom Menus to modify or remove existing menu items. With Custom Menus, you could allow people to perform a Ctrl-J but run your own script that finds just the A, B or C records.

  • Author

Ok, this sounds like what I am looking for, but I am not sure where to get started? How do I go about overloading the Ctrl-J cmd to run my script?

Since you already have FileMaker Advanced, look at the Tools menu and you will see Custom Menus.

Create an account or sign in to comment

Important Information

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

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.