-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|