I am working on an e-commerce application and I need help with
updating the product details for a single product with multiple
fld_prodID (PK, autonum)
Product Formats table:
fld_formatID (PK, autonum)
If I wanted to update this product and select multiple formats, would
I have to build two update queries or could I do it with one? What
would the SQL look like?
Thanks for your help and suggestions!