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
Printable View
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
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