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.

How to Hide Duplicates?

Featured Replies

  • Newbies

I'm porting a database from Access to FileMaker Pro 6 (for Mac). In Access, you can set a control field to Hide Duplicates. So, if you have the following body lines:

Mazda   Miata

Mazda   RX8



Triumph GT6+

Triumph Spitfire
and the first column is the summary break field, then you will get:


Mazda     Miata

                 RX8



Triumph GT6+

                 Spitfire

I'm trying to figure out how to do this in FileMaker.

When I create a normal sub-summary report with the break field in a leading subsummary part, it doesn't print both the control field and the other report fields on the same line.

I read somewhere that sliding objects will slide through most parts, so I tried to get the body fields to slide up into the subsummary part. That didn't work.

Right now I've got the break field as a calculation that checks to see if its current record number is the same as the Minimum record number in that group. (If this is the first record in the group, it displays the field, else the result is blank.)

That gives the effect I want, but the only problem is when a body - group goes over a page break, the break field doesn't display on the first line of the page. I don't know how to detect in the body if the record is the first body record on the page.

Question: Is there an easier way to do this?

Thanks...

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.