Inserting Data in Table (RelationShip Problem)
-
Hi EveryOne, I have created 1 table in my DB named F-orgs containg only 1 field F_orgs. And it’s the primary key. Its Data Values are F_orgs F01 F02 F03 F04 and other table Item_Details having F_Orgs as the foreign key. and One Item can be used by multiple F_Orgs. Now the prob is that: My table Item Details is not accepting multiple values under F__orgs field. It is only taking 1 value like Item_No F_orgs 1414-3635 F01 1414-3636 F02 I want this Item_No F_orgs 1414-3637 F01, F02 1414-3638 F02, F03 And it is but obvious while inserting it is checkn values with F_Orgs Table (Relationship Bw F_Orgs and Item_Details Table) Rite. So is my logic going wrong somewhere. Can anyone have any idea, where i m going wrong. Plz tell. Regards
-
Hi EveryOne, I have created 1 table in my DB named F-orgs containg only 1 field F_orgs. And it’s the primary key. Its Data Values are F_orgs F01 F02 F03 F04 and other table Item_Details having F_Orgs as the foreign key. and One Item can be used by multiple F_Orgs. Now the prob is that: My table Item Details is not accepting multiple values under F__orgs field. It is only taking 1 value like Item_No F_orgs 1414-3635 F01 1414-3636 F02 I want this Item_No F_orgs 1414-3637 F01, F02 1414-3638 F02, F03 And it is but obvious while inserting it is checkn values with F_Orgs Table (Relationship Bw F_Orgs and Item_Details Table) Rite. So is my logic going wrong somewhere. Can anyone have any idea, where i m going wrong. Plz tell. Regards
I think your insert should be trying to get records like this: 1414-3637 F01 1414-3637 F02 1414-3638 F02 1414-3638 F03 When you put comma separated values into a field, the DB checks that the string as a whole matches a single entry in the F_Orgs table.