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 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.).
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 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.).