I have a number of one-to-many joins in my product database, for a site I am updating
For something like product groups, this approach works really well, i can assign a product to as many groups as I need.
I have followed the MJoin example and successfuly updated the datatable and editor on the page.
For product colours though, this doesn't quite work as I need
As an example, I have product colour options, so there is a tblproduct table (parent), tblproductcolour table (link) and refcolour (child) table
To complicate things a little, the tblproductcolour link table also contains a price field, as each product / colour combination can potentially have a unique price.
if, when editing a product, i add or remove a product colour from my options, not only is the row removed, but all of the existing prices are set to zero
is it possible to add the price field in my link table in my mjoin ?
i have a test page at http://test.forthwebsolutions.com/hutch4dmin/products.php
This question has an accepted answers - jump to answer