Results 1 to 2 of 2

Thread: MS Access 97 solution HELP

  1. #1
    artman Guest

    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.

  2. #2
    Stephen Wynkoop Guest

    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
  •