Database option setup
The way my database is setup I have a product table with the SKU, Name, Base price, Desc. and so on. I also have a productoptions table that has a sizeID, size name and a price increment to add to the base price e.g. New Born adds $0.00, Small adds $1.50 and so on. What actually happens with my current configuration is; when a size is chosen the price in my productoptions table replaces the base price in the product table instead of being added to it.
It makes sense to have a recordset connected to my add to cart server behavior, but I don't understand how to make that work.
See attachment for Database Structure.
Thanks for your help!