Copy record to other table and delete from original table

[jadeddirector]

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!

[mr_vodka]

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

[Merit Solutions]

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)

[mr_vodka]

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.

[Merit Solutions]

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?

[mr_vodka]

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.