Results 1 to 6 of 6
  1. #1
    Join Date
    Jun 2007
    Posts
    19

    Unanswered: HELP with Forms!!

    With forms, I created a subform in my Order Form.
    In my form i have customer information, and in my sub form i want to have the products which the customer wants to order.

    So in my subform i will need Product Name, Brand, Quantity and Price. I designed the subform using wizard, however there are no values. Do i have to create a Query so if a customer orders a product e.g. Product Name: Pentium 4, the brand name, price will automatically come up.

    Also how would i make it so customers can order multiple products, not just one?

    I have attached the database
    Attached Files Attached Files

  2. #2
    Join Date
    Nov 2005
    Posts
    113
    I think the relationships must look like this.
    Attached Files Attached Files

  3. #3
    Join Date
    Jun 2007
    Posts
    19
    Whoops sorry i was suppose to remove the payement table

  4. #4
    Join Date
    Nov 2005
    Posts
    113
    Look at the foreign key and many to meny relationships i did in the word document.

  5. #5
    Join Date
    Jun 2007
    Posts
    19
    i don't understand what that has to do with my question?

  6. #6
    Join Date
    Jun 2007
    Posts
    19
    sorry Julita maybe you are right. I think my relationship is wrong. Does anyone else here agree?

Posting Permissions

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