I've created an order entry db and I'm having some trouble designing a feature that would
create a separate price list for each separate customer.

i.e. when i select a customer to fill an order form for, i can do a lookup of their separate
price list as each every customer is given a separate price for the same product.

How do i setup an autolookup of the price list and and auto fill of the selected customers
pricing, into my orders form.

Any help would be great.