I have a customers table where the customers are assigned a pricing level, 1, 2 or 3. The products table has cost price and 3 saleprice levels 1,2, and 3. How do I make the orders form show the unitprice being the saleprice relevant to the particular customers pricelevel? Is it a dlookup function or something else? Is it place on the form or within the query?

Thanks