Jump to content

Grouping data from related records


Auditiaan

This topic is 7079 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 7079 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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