prevent repeatition in fields which is not a primary key

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Matilda said:
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.
Click to expand...

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)
 
Back
Top