prevent repeatition in fields which is not a primary key

[Guest]

I have two table with the relationship 1: many
Table 1 fields are A, B, c where c is the primary key
Tabe2 fileds are D, C, E, . whre D is the primary key
I are using subform to capture data but I do not want to repeat the same
values for C and E in table 2 . how do i go about it.

 

[Rick Brandt]

I have two table with the relationship 1: many
Table 1 fields are A, B, c where c is the primary key
Tabe2 fileds are D, C, E, . whre D is the primary key
I are using subform to capture data but I do not want to repeat the
same values for C and E in table 2 . how do i go about it.

Open Table2 in design view and then from the menu choose View - Indexes. You
want to add a unique index that contains both fields C and E. It will look
like...

IndexName C
E

(*) Unique (found at the bottom of the dialog)