How to Hide Duplicates?

[Michael Schmitt]

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...