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.

"Grouped By" Query in Filemaker

rafiki607
in Relationships

Featured Replies

  • Newbies

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

Picture_1.png

Create an account or sign in to comment

https://fmforums.com/topic/47668-grouped-by-query-in-filemaker/
Go to topic listing

Important Information

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

I accept

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.