-
unique name
Hi
I don't have much experience in access, I created a department table and I want to make some validation to stop same department be input twice, I have department id as prime key
thank you
________
ANGELINA JOLIE PICTURES
Last edited by sql; 03-06-2011 at 01:24 AM.
-
1. Make department name as primary key
or
2. Create index with (no duplicates) on the department name
-Rightclick on the table - Design table - click on 'department name' - click in 'index' in the property window
-
Mak:
thank you!
________
Honda rc160
Last edited by sql; 03-06-2011 at 01:24 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|