Hi, Before reply plz understand this situation.
I have one table 'T1' having one integer filed configID as primary key. This table has some existing data in it. I created one more table T2, in this table I made one integer filed ID as foreign key reference to configID of T1. Now I am dealing with only T2 not T1, I.e. I am inserting field values in T2 columns only not T1 (Since T1 has already some data).
The requirement is when I will insert data into T2, ID filed may be inserted or may not be inserted. Inserting any value from T1 configID is fine but when I am not inserting its throwing error since it has foreign key reference. So how can I insert/update record in T2 without the value of configID? Thanks in advance. Help will be highly appreciated. Himansu
|