Hi Jason, thanks for your help on the ticket. I would now like to simplify my insert and update pages.
The attachment shows the insert and update pages which enter and update data in the products table and the linking productoptions table.
At the moment the checkboxes display all the options for all produts. This is not ideal due to the number of options, wrong selections can easily be made.
On the insert page is it possible to only display the relevant options for the product category as soon as it is chosen at the productcategory dropdown.
Also the same option checkbox choices would need to be displayed on an update page showing the option data stored in the database.