I have the following tables: Jobs and Lines. I currently have a layout showing a list of Lines, sorted in the following order:
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!