Hello all,

I have two inventory tables, one with available inventory and one with sold inventory. I want to be able to select a field within a record in either of these tables that will move the record to the other table and delete it from the current table. I have no experience with scripting so I'd appreciate any assistance as I simply don't know where to start.

Thank you!

Why not keep it in one file with a status field?

Isolate the source record:

[color:blue]Show all Records

Omit Record

Show Omitted Only

Import Records

(from source to destination table)

Delete isolated record in source table (then Show all records in source table)

This would work (until fields are changed around that will break the field mapping) but I still would like to know why the OP wants to do this. A simple status field could solve the issue.

I am curious about field mapping breaking and fields "changing around". Whenever I have scripted imports, the field mapping is always restored...could you please expand?

See this post.

http://fmforums.com/forum/showtopic.php?tid/190120

If moving fields around in the import order or deleting one in the middle on the SOURCE side, you will have to remap.