Records from one table to new records in 2nd table

[the_jetset]

I have a situation where there are 4 Tables.

Table 1: PURCHASE_ORDERS

Table 2: PURCHASE_ORDER_ITEMS

(These are related with the PO_ID. There is a portal in PURCHASE_ORDERS that shows all of the individual products that are in that specific Purchase Order)

Table 3: WAREHOUSE_MOVEMENT

Table 4: WAREHOUSE_MOVEMENT_ITEMS

(Again, these two tables are related through the WH_Movement_ID there is a portal in WAREHOUSE_MOVEMENT table that shows all the individual items in a particular warehouse movement.)

I

[the_jetset]

Nevermind! I figured it out!!

I first retrieved all the related records from PURCHASE_ORDER_ITEMS using the function: GO TO RELATED RECORD.

Then, I imported all of the related records into new records in the WAREHOUSE_MOVEMENT_ITEMS table.

[JanB]

jetset - you could really help me out - i have similar situation.

Would you post or email me([email protected]) the script you used to solve your problem?

many thanks

JanB