Grouping data from related records

[Auditiaan]

Hello guys,

I am totally new to Filemaker. So forgive me if I don

[Ugo DI LUCA]

At first glance, this is nothing complicated.

If you know in advance what your categories are, create orphans records with just the category filed with each of your categories.

cSort = Category&aspect will be used as your sort key for this relationship so that the Categories would appear in the correct order.

If you need some indent, then use a calculated display field.

If you don't know your Categories in advance, you would need a new Table Occurrence with a Relationship on the Category field, and then some more settings, but nothing impossible again.

The second scenario would be slower than the first.

Tell us if this makes sense.

[Auditiaan]

Thanx Ugo DI LUCA for replying.

I did a sort on category and aspect and also created a script which I use to copy the data to another table. In preview mode it all looks good. Only in browse mode I couldn't get it working. I don't know if that's possible? Still the solution is good. Thanx for your help.

Greetings, Auditiaan

[-Queue-]

I'm assuming you are using subsummary parts, which are only visible while previewing or printing.

[Auditiaan]

Yes Queue, I am. I was hoping to see the same in browse mode, but I didn't. But that isn't a problem anymore...