I have a table with the following fields:
format
region
rarity
they are all set to lookup value lists:
format: tape; dvd
region: 0;1;2;3;4;5;6;7;8;pal;ntsc
rarity: 1;2;3;4;5
I have a check that makes sure (format, rarity, region) is unique.
It works fine until i set region to either "pal" or "ntsc", then I get the following error.
"Error 'Error evaluating CHECK constraint. ' in the validation rule."
I set up the constraint by going to table design view -> indexes -> created new index with each of the three fields listed one after another -> set to primary=no, unique=yes, ignore nulls=no.
Can anyone help me work out why im getting this problem?
format
region
rarity
they are all set to lookup value lists:
format: tape; dvd
region: 0;1;2;3;4;5;6;7;8;pal;ntsc
rarity: 1;2;3;4;5
I have a check that makes sure (format, rarity, region) is unique.
It works fine until i set region to either "pal" or "ntsc", then I get the following error.
"Error 'Error evaluating CHECK constraint. ' in the validation rule."
I set up the constraint by going to table design view -> indexes -> created new index with each of the three fields listed one after another -> set to primary=no, unique=yes, ignore nulls=no.
Can anyone help me work out why im getting this problem?