Richard,

If I have multiple vendors for items in stock and I have a junction table with that info, how would I go about selecting the vendor with the lowest price?  Would that happen in the query with a dlookup? or is there an easier way to do this?

---

Reply from Richard Rost:

You can use a DMIN to find the lowest price, then DLOOKUP to get the rest of the info

LowestPrice: DMIN("UnitPrice","VendorProductJunctionT","ProductID=" & MyProductID)

Now that you have the lowest price, just DLOOKUP the product ID and from that you can get the vendor ID. Of course, if two vendors have identical prices you'll get one at random. I suppose you could specify a priority order for vendors and then sort based on that. :)