I know I can make a column unique as a constraint via the schema. Is there a way to make the combination of two fields be unique?
for example, lets say I have two columns id and attribute
ID attribute
100 b
100 c
so if I tried to insert ( 100, b ) it would generate an error and not allow the insert
but (200, b) would be fine as would (100,f)
Thanks,
H
ps. having a blast working on this project.