If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
prevent repeatition in fields which is not a primary key
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 |
Thread Tools | |
Display Modes | |
|
|