Sorry am a little confused- yeah I know, not hard!
there are 3 'products' (which need to be editable by the client):
Varilux /iDay 13 Delegate
All Other Delegates
Practice Team (3 People)
Each product has got 3 options (again, need to be editable by the client)
iDay only
iDay/iNight Single
iDay/iNight Double
Each of those 'products' has got 3 possible prices based on whether its full price or one of the 2 early bird prices (dates need to be editable by the client)
Due to the need to be able to edit and add/remove product, option and price and choose any combination, that setting up 3 tables.
ProductItems (for the Varilux /iDay 13 Delegate, All Other Delegates, Practice Team side of things)
ProductOptions (for the iDay only,iDay/iNight Single, iDay/iNight Double side of things)
CombineProduct to pull the 2 above together (with dynamic drop downs) and including the price as a text input...
How would I achieve that with a 1 table version?