Hi,
I need your help!
I have three files, 2 Master and 1 with the relationship between them.
MasterA(0,n)->(1,1)/RelationAB(1,1)<-------------(0,n)/MasterB
(UK,AID)MA.Key..../(KD)MA.KEY............................../(UK,AID)MB.KEY
(KD)MA.Code......../(KD)MB.KEY
............................../(KD. add manually)MA.Code
............................../(UK,CK)MB.KEY,MA.KEY
............................../(UK,CK.add manually)MB.KEY,MA.Code
(UK) Unique Key
(AID) AutomaticID
(KD) Key with duplicates
(CK) Composite Key
Then I fill the values via application:
MasterA /MasterB /RelationAB
A1.........../B1........../A1
COD1..../.............../B1
............................../COD1
............................../B1,A1
............................../B1,COD1
I have added manually MA.Code & CK MB.KEY,MA.Code because I can't permit the same relation of MasterB.Key with MasterA.Code value.
The question is Why is HF C/S taking as ok?:
MasterA /MasterB /RelationAB
C1........./B1.........../C1
COD1.../................/B1
............................../COD1
............................../B1,C1
............................../
B1,COD1
B1,COD1 It's a duplicated Unique Key!!!
Regards