Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004

    Unanswered: Selecting multiple options

    Hi, I'm currently stuck in the middle of my access project. It's basically a project that revolves around a shop so i've got a customer details form, product info form and order & order details form.

    My problem is, that i cant figure out how to select multiple products on my order form whilst keeping them with the one order id. i have product id and order id as primary keys + autonumbers.....

  2. #2
    Join Date
    Jan 2004
    Aberdeen, Scotland
    Is this a homework project?
    if so ill give you some pointers to at least how i would tackle this but i wont go into detail,
    I would produce a new table that would hold orderid and product id and have its own id,
    Then query this to get multiple products by order

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts