1 2 Previous Next 19 Replies Latest reply on Apr 26, 2017 7:46 PM by fireballprinting

    Sort Grouped by Related Record

    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!

        1 2 Previous Next