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