fireballprinting

Sort Grouped by Related Record

Discussion created by fireballprinting on Apr 24, 2017
Latest reply on Apr 26, 2017 by fireballprinting

Hello,

 

I have the following tables: Jobs and Lines. I currently have a layout showing a list of Lines, sorted in the following order:

 

star

status_job

date_due

time_due

 

I'd like to keep this basic sort order, but modify it so that line items from the same job are grouped together, even if they have different values. For example, if one line item is starred, and another line item from the same job is not starred, they would both show at the top of the list together. I can accomplish this by creating fields on the jobs table and sorting based on those, but that slows things down a lot. Any suggestions would be helpful! Thanks!

Outcomes