I see so the downloadable database from your website has been created to do exactly what I need (as described in first post) without having to mess around with the database structure. I just want to get this sorted in my head before I start out coding my ecart and then realising it wouldnt be possible with the method im using.
with this same topic, How woudl I go about structuring a "additional options" on the Admin creation screen...for example an Admin logs in, creates a "new product", so then they would need to assign some product options...now what would be the best approach..would they then be taken to a second screen where they can create new product options because previous product options could have been created and these are already stored in a database, so it would be silly to re-create the same options (but then again a product may include 8 out of 10 additional items in a product option.
Its quite frustrating working out the best approach. I think my head will explode in 10 seconds.
What woul dyou suggest as a workflow for the Admin screen so that my client can create a new product and then either assign or create a new product options listing? (im only asking on this forum since im using the Web Assist database) :)