How to insert data from 2 related tables to keep their connection via ID (PK, FK)

There is a main table Producers and subordinate Goods.

*************** ***Producers*** *************** producer_id prmary key, Producer_Name ************ ***Goods**** ************ Id Primary key, producer_id Foreign key, Good_Name 

Using IBEXPERT, I pulled the data from Producer, but when the script inserts it into a new table, their connection is lost. If, for example, in Producer eats such data:

 PRODUCER_ID PRODUCER_name 41 AAA 42 BBB 43 CCC 

after inserting the data with the sql-script in the PRODUCERS table of the new database

 INSERT INTO PRODUCER (PRODUCER_ID, PRODUCER_name) VALUES (41, 'AAA'); 

the generator assigns the manufacturer a 'AAA' ID instead of 41 a new value of 1, 'BBB'-ID 2,' CCC'- ID 3, etc., and 41,42,43 is correctly assigned in the slave table. those. data integrity is broken? (see screen).

How in IBEXPERT to pull the data from the oboyh tables so as not to lose their connection through Producer_id?

UPDATE: When I turned on the "Extract All" checkbox and reads all the data from both tables, then everything correctly inserts into the new tables, the main table ID is correctly stored (41st ID for "AAA" .42nd for "BBB", etc. or as in the screenshot, the 50th ID is correctly assigned "222"). How, I can not understand!

After all, first of all, new domains and generators are created, then tables, then inserts records, then foreign keys are created, and then triggers are created. While the record is inserted and then triggers will work? How and at what stage is data integrity ensured? If a lonely table then the generator ignores my ID and increments the last ID, and if the related tables then ...?