Validate against two columns in a database to prevent data insertion
I am trying to do a multiple item insert so that I can add a product to multiple categories. I have is setup using checkboxes and hidden fields to insert the needed information. Is there a way to get the insert behavior to check the database against two values in the table?
Essentially this table combines the ItemCatID from my categories table and my ItemID from the items table to have a one-to-many relationship between items and categories (I think this is the best way to do it). I want DA to check and make sure the combination of ItemCatID and ItemID do not already exist to prevent a duplicate insertion. Any thoughts on this?