Filter table results via relationship? Question...

[NickFaraday]

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.

[John Mark Osborne]

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.

[NickFaraday]

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?

[John Mark Osborne]

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