Quick Access Q

[Bakedgoods]

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?

 

[Bakedgoods]

Thanks Fez, just wanted to make sure it worked the same (and like you said the indexes form is a little odd).

Cheers!