Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2008

    Unanswered: adding new products to customer record

    hi, i'm in need of some help. i've created 2 different tables and im gonna be creating one main screen as a form. the one table would be all the customers information and the other a product table.
    what im trying to do is on my form i would be able to add the products that have been talked about to the customer and adding them on a subform?

    so it could be a sub form with all the products talked about. some customers could have only talked about 1 product and other all of them

  2. #2
    Join Date
    Feb 2004
    One Flump in One Place
    This is called a many to many relationship. You need a junction table (this is known other names as well) that has two one-to-many relationships: a customer may discuss many products and a prodcts may be discussed by many customers.

    This table contains a composite primary key of the two tables. This means take the primary key columns from your people and product tables, shove them into this customer_products table and make all the columns the primary key.

    This is the starting point. Once done, we can get onto the form.
    pootle flump
    ur codings are working excelent.

Posting Permissions

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