hello everyone, I wanted to know the equivalent for the keyword 'UNIQUE' which is used in SQL to make two columns into a Composite key, in MS-Access.
If you do not know about the UNIQUE keyword in SQL, basically all I want is to make to columns a composite key. Meaning: Just Like if you were to make them primary keys except they are not primary keys they just follow the validation rule:
example
X Y
1 1
1 2
3 2
2 1
If X and Y were composite keys, I could add any value in X and any value in Y as long as I don't repeat the values leading to them
for example 3 2 is not permitted because it already exists but 3 1 and 2 2 is because only one of the keys is repeated and not both. if that made any sense please help...
If you do not know about the UNIQUE keyword in SQL, basically all I want is to make to columns a composite key. Meaning: Just Like if you were to make them primary keys except they are not primary keys they just follow the validation rule:
example
X Y
1 1
1 2
3 2
2 1
If X and Y were composite keys, I could add any value in X and any value in Y as long as I don't repeat the values leading to them
for example 3 2 is not permitted because it already exists but 3 1 and 2 2 is because only one of the keys is repeated and not both. if that made any sense please help...