Check for duplicate rows in 2 columns before update
- by user3891378
I have a table with 4 columns, and I need to check to see if a Column Pair exists before inserting a row into the database:
INSERT INTO dbo.tblCallReport_Detail (fkCallReport, fkProductCategory, Discussion, Action) VALUES (?, ?, ?, ?)
The pair in question is fkCallReport and fkProductCategory.
For example if the row trying to be inserted has fkCallReport = 3 and fkProductCategory = 5, and the database already has both of those values together, it should display an error and ask
if they would like to combine the Disuccsion and Action with the current record.
Keep in mind I'm doing this in VBA Access 2010 and am still very new.
