Exporting data to another table???

[SoundPad]

Hi.

I'm trying to export data from one table to another. Basically i've created a Sold table and a Stock table. When a product has been sold i want the item to be moved into the sold table. Is there a script to do this?

Kind Regards

Elliot

[Raybaudi]

The logical way is:

1) Isolate the record (s) that you want to export

2) Import that (those) record (s) into the Sold table

3) Delete that (those) record (s) from Stock table

[Stuart Taylor]

Check this out too ... Similar recent topic

In my opinion (as someone who deals with stock inventories) sold is a field containing a status (For Sale/Sold)

[SoundPad]

cheers perfect...

many thanks