MS Access 97 solution HELP
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.
MS Access 97 solution HELP (reply)
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.