"Grouped By" Query in Filemaker

[rafiki607]

Hello Everyone!

I am pretty new to Filemaker- most of my knowledge is in Access- and I am having a difficult time creating a grouped by query which is very easy to do in Access.

What I have is 2 tables each with 2 fields.

Table: PartNumber

Fields: PartNumber, Component

Table: Alternates

Fields: Component, Alternate

I want to show all the records in the PartNumber table along with its components and any Alternates if applicable.

For Example:

Part1 Component1 Alternate1

Part1 Component1 Alternate2

Part1 Component2

Part2 Component1 Alternate1

Part2 Component2

Part2 Component3 Alternate1

Part2 Component3 Alternate2

Part2 Component3 Alternate3

In essence, all PartNumbers have multiple Components and some Components have multiple Alternates.

I have added a screenshot of the access query to better explain the relationship.

Thanks!

Michael