Copying Data From 1 Tbl To Another..Part 2

[Creeder]

Hi all,

This another copy from table to table question.

I have 2 tables. When i tried copying 1 table to the other
i get an error msg

INSERT statement conflicted with COLUMN FOREIGN KEY constraint.

Eg data from table 1
Cust_id Line_no
AA123 1
AA123 2
BB1234 1
BB1234 2
BB1234 3
...
...

I am basically doing a INSERT INTO...SELECT ..FROM statement
to copy the tables on SQL 6.5. Is there a work around to this problem?

THanks in advance

 

[Creeder]

I should also mention that the cust_id and line_no are the key fields.

Thanks

 

[Cagliostro]

You can not insert in place or foreign key as values as are missed in table source for this key. John Fill