Hello ib-support@egroups.com!

I have:

Create Table Year_Definition (ID integer not null,Year D_Year not
null);

Create Table MyTable1 (ID integer not null,Year D_Year not null,...
Create Table MyTable2 (ID integer not null,AssignedTo integer,...

Foreing keys:
MyTable1.Year-->Year_Definition.Year
MyTable2.AssignedTo-->Mytable1.ID


and I need copy data from old year to new, but other columns of tables
is only copied.

How to do it ?

--
Best regards, TRoland