Hello all,
I've got to import the MsExcel file with data under my primary key which contains duplicates on this key. Evidently, I create the child table with the mentioned key as the foreign one and with new incremental primary one in order to accommodate these duplicates (they are duplicates only in regard to my primary key).
For ex.:
Master table:
Field1 int, autoincremental primary key
Field 2 varchar
Child table:
Field1 int, foreign key
Field3 int, autoincremental primary key
Field4 varchar
Table to import
Field1 int
Field 4 varchar
The idea would be to import Field4 values under the child table where Field4 (child table) = Field4 (table to import) and incremental values for the Field3 to be assigned automatically.
However, how to?
