enrollment duplicates

[Soldats]

Hi, I'm done with developing a database for training electricity engineers. All tables, forms, queries, reports, etc are finalized.

The only thing is:
I have three tables: Engineers, Sessions, Enrollments.
the Engineers and Sessions are related many-to-many..that's why I'm using the enrollment table to break the many-to-many relation.

The Enrollment table has these fields: Enroll_no(as primary key), Engineer_no(as foreign key), Session_no(as foreign key).

I do not want duplicates. That is: no compination between Engineer_no & Session_no duplicates.

Please, guide me to fix this

 

[DCrake]

Simple Software Solutions

Go to the design of your table and ensure that the two or more fields that make up your uniqueness are the first fields. Drag the mouse over the fields to highlight them and click on the Key icon button (Primary Key) opn the toolbar. Next save the table changes. this will ensure no duplicates.

CodeMaster:

 

[Soldats]

Thank you. It is working fine now.