I have a form where I am trying to pull up vendors and sales order numbers from a query.  The vendors can be duplicated but, the sales order numbers can not be duplicated by vendor.  In other words, I may have a vendor "ACME" with an order # 051123BKN and I can also have another order with vendor "T&B" with an order # 051123BKN but I cannot have two of the same order # with either vendor.  When I try to pull these up in my form (via qry), it always selects the first order for the vendor, even though I may have 10 orders with different order #'s under ACME.  It always pulls in the first record.  How do I move past this and get the actual record I am trying to select?