Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Unanswered: POs and closed PO lines (was "I think this is an easy one..")

    I have a table for PO's and a table for PO lines. I need to select the list of PO numbers where the related PO lines are closed. What is the best way to do this. My first inclination is to write a query to count the number of attached lines for each master PO and then correlate a subquery selecting the count of closed lines and where they match close the master PO. Is that the best way to do this or have I overthunk. TIA

  2. #2
    Join Date
    Jun 2003
    West Palm Beach, FL


    Count the lines that are NOT CLOSED and if ZERO, then close the master PO
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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