I think I am close, however, my script will not copy the fields from Table A to Table B.

Background:
In Table A users are importing data into about 20 fields. Once they confirm that the data is correct, I want it to be copied to the Table B for continued use. Table A is just 1 record that is used to confirm the fields are correct. Once validated I would like to move it perminantly to Table B.

Here is my script so far:

Go To Layout ["order tracking"(order tracking)]
new record/request
enter browse mode []
set field [order tracking::name; order import::name]
set field [order tracking::PO number; order import::PO number]
set field [order tracking::quantity;order import::quantity]
commit records/requests

Any idea why the records are not being copied from Order Import (Table A) to Order Tracking (Table B )?

Any help would be greatly appreciated!

Thanks in advance.

John

Hi John,

Perhaps set up an 'import' script in Table B and match the fields that way, rather than do it through a 'set field' script?

Hope this helps,

David