Can DataAssist wizard include "product options"?
This is only my second attempt at working with databases (the first went OK), so please bear with me!
The site I'm developing needs products, and category and colour options.
I've been following the DA Getting Started Guide, and succeeded in setting up a set of Product_Results/Insert/Update/Detail pages. However, as I want also to be able to include product colours, I tried running the wizard again (having first moved the resulting files to another folder).
It looks to me as though productionoptions doesn't have a column in the products table (as productcategories does). Instead, the foreign key (if I've got this right!) has to go through the productoptions table in order to be linked to the options table. Is that right?
I did try setting the ProductID as a menu item dynamically linked to OptionID (in a similar way to that done with productcategories), but Dreamweaver crashed mid-way through creating the first of the pages.
I wonder if the wizard would work if I added a column OptionID to the products table. Or have I got this completely wrong?!
I'd be very grateful for any help/advice you can offer.
PS I've populated the options table with data
so there are data to pull in.