prevent repeatition in fields which is not a primary key

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.

Matilda wrote:
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)

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com