Originally Posted by
rpeare
I wouldn't attempt to do this in your table design (validation rules) I would do this on the data entry side (forms). You can create rules that happen before a record is added or updated in your database to look up combination so of dvdid's and scores to either allow them or disallow them from being entered or updated.
I'm confused why you wouldn't allow the same score for a different ID though. Are you doing a survey of favorite movies where someone has to rank a dvd from 1 to 10 (10 dvds) so there can only be one occurance of each score?