
Having Problems with concatenated indexes (primary keys)
HELP!!!
I am having difficulties defining a concatenated Index.
My index should consist out of PC_Number and Component_Number, two
fields in a table.
This is what I used to do in VB3:
Dim IDX As New Index
IDX.Name = "PC_Comp_Idx"
IDX.Fields = "PC_Number ; Component_Number"
IDX.Primary = true
IDX.Unique = true
This is what I'm doing in VB4
Dim PCIdx As Index
Dim IxFld(0 to 1) As Field 'Used in another case to define two index
'fields
Set PCIdx = PCTb.CreateIndex("PC_Comp_ID")
PCIdx.Primary = True
PCIdx.Unique = True
Set IxFld(0) = PCIdx.CreateField("txtPC_Number ; txtComponent_Number")
I know I'm doing something wrong, PLEASE if you've got any help
E-Mail me
Thanks in advance
PJ Groenewoud