I have a junction table with composite PK on 3 fields...
[fldA], [fldB], [fldC]
I also need values to be unique across 4 values...
[fldA], [fldB], [fldC], [fldD]
I cant add the [fldD] column to the pk cause then 2 records could have the same data for [fldA], [fldB], [fldC], and that would be bad data.
Was going to add another unique constraint using all 4 fields.
Is that the best most efficent way to handle this?
Table will most likely have few records from 5 - 100.