- Joined
- 31 Dec 2003
- Posts
- 5,172
- Location
- Barrow-In-Furness
It's been a bit since i've used this so i'm looking for some help..
If i've got a table along the lines of...
ID - PK
Name
Building
But I need to make sure that Name and Building are unique, so you can have the same name but for different buildings, but not the same name for the same building.
In SQL I would just have Name and Building set as unique Index keys, does this work the same in Access?
If i've got a table along the lines of...
ID - PK
Name
Building
But I need to make sure that Name and Building are unique, so you can have the same name but for different buildings, but not the same name for the same building.
In SQL I would just have Name and Building set as unique Index keys, does this work the same in Access?