Hi, I am new in MS Access.
I am designing a Database for a HRM.
I have seven table
1. emp_personal_info
2. emp_office_info
3. emp_activity
4. salary
5. increment
6. leave
7. extra
Each table has the same ID and only emp_personal_info's ID has declared as primary key. all the tables are connected as one-to-many relation.
The emp_personal_info table's ID is not taking duplicate value. But all the other IDs of other table ar taking duplicate value.
How can i stop this ? Please suggest.