Results 1 to 4 of 4

Thread: Orders containing products

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #3
    Join Date
    Sep 2011
    Location
    Minneapolis, MN
    Posts
    185

    Default Re: Orders containing products

    OK, that is giving me the expected result but I noticed that I may have not specified properly.

    Using the same example, when I filter for two values (Asphalt & Striping) I only want to see one JobNumber but it shows it multiple times.

    Job# 1111

    - OrderDetail1 - Sweeping

    Job # 2222
    - OrderDetail1 - Striping
    - OrderDetail2 - Striping
    - OrderDetail3 - Striping

    Job # 3333
    - OrderDetail1 - Asphalt
    - OrderDetail2 - Striping
    - OrderDetail3 - Sweeping

    Results in:
    JobNumber | Activity Type
    2222 | Striping
    2222 | Striping
    2222 | Striping
    3333 | Asphalt
    3333 | Striping

    Ben
    Last edited by Benjamin; 15-Jun-2018 at 09:21 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •