Jump to content
Sign in to follow this  
Auditiaan

Grouping data from related records

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.

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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