Adding Product Options
I have an "Add Product" page which contains a DA insert form to add the product details to my items table. I also need to assign various options to the product, such as available colors and sizes, which I will do with lookup tables. I'm guessing this has to be done on a separate page, so I'm doing the first insert of the basic data and then redirecting to the "Add Options" page. A couple of questions:
1. How do I get the just created itemID of the added product to the "Add Options" page so I can filter the recordset of items to select that item for insertion into the lookup tables? Or do I need to do that?
2. Can I add the itemID into two different lookup tables (itemcolors, itemsizes) on a single page?