Printable View
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.
Create a query and use that query to populate the field or drop-down. you can pass parameters to the query to limit the scope to the current customer.
SW
On 1/7/99 1:48:38 AM, artman wrote:
> 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.