Multi-record insert/append using sub-query list - and Binary Links

[Barry G. Sumpter]

Hi all,



INSERT INTO OldOrders ( order_num, order_date, amount ) 
SELECT order_num, order_date, amount
FROM orders
WHERE order_date < '01-JAN-90'

Lets say that the sub query returned 100 orders records.
Lets also say that the OldOrders table has a binary link of 1 to M with a
shop table.
i.e. each shop has many many OldOrders

is there a way to update the binary link with the same Insert?

If not, any suggestions?

I'd rather not have to execute a single Link Record command for each of the
100 order records.

Thanks