With conditional formatting and the getNthRecord function, you can make the repeat entries invisible. Use an expression such as:
If ( Get (recordNumber) > 1 ; GetNthRecord ( YourTable::Origin ; Get (RecordNumber ) - 1 ) = YourTable::Origin )
and change the text color to match the background or set the text size to very large (120 points or larger for fonts near 10-12 points in size.)
but you might also consider reformatting your output to look like this:
Type: Fume Blanc
Maker Special Price Issue Rating
This second option is possible in a list view using sub summary layout parts.
Hi Phil - thanks for your response - I was just waiting a few days to see if others might respond w/ suggestions - from your description, appears that I need to set up some 'formula' to print out in the format desired - not sure that I completely understand your second 'reformatting' output option - NOW, I've not purchased this program yet, so am still considering? I'm still somewhat amazed that Access has not been transitioned over to OS X is some easier fashion - UGHH - thanks again! Dave :)
Did you look up the term "conditional formatting" in FileMaker Help?
It is a calculation, but not defined in a field in your table, it's a property you set on the field object on the layout.
The second approach is a summary report. I did not spell out the details of how that would be set up as I did not know if you were interested in that option. If you are, let me know and I'll describe how it works. To me, it would make for an easier to read report format, but it's your call to make.