Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2009
    Posts
    9

    Unanswered: Junction table "lookup"

    I have three tables:

    1. PRODUCTS
    ProductID
    ProductName

    2. PRODUCT_CATEGORY
    Product_CategoryID
    ProductID
    CategoryID

    3. CATEGORIES
    CategoryID
    CategoryName

    I want to make a Form where I can edit one product at the time and on that form have a subform where I can add categories to that product (A product can belong to many categories).

    If I use the "make form wizard" on the product table it only results in a subform with PRODUCT_CATEGORY table (wich only shows ProductID and CategoryID). How do I get a subform that make it possible to change category by the CategoryName and not the CategoryID? (I dont want to use the "lookup function" since it messes with my relations etc.).

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    On your form, use the combo box wizard to add a combo box. It should get its values from the CATEGORIES table but save to the PRODUCT_CATEGORY table. If you answer the questions appropriately, it will display the text to the user but save the ID.
    Paul

Posting Permissions

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