Linking 3 database files

[hankball]

I have four database files; Customer Information, Item Entry, Sales Order, and Sold Goods. I assign an arbitrary number to each item entered when we receive it into the warehouse. We use that same number in a field called Item Number in Sales Order. I need to set up a routine so that when the Item Number is entered into Sales Order then the information about the item is copied from Item Entry to Sold Goods and then deleted from Item Entry. Is this possible?

Thanks.

[CaelC]

You could trigger a script to do exactly that from a button on your layout, after you enter the number, click the button, run the script, done. However, it seems like this data shuffle would be unneccessary if you set up the files differently. Maybe you don't really need to delete from the one file and move the sold info to another, maybe you can just mark the original one sold and leave it in there as historic data.

Of course I don't know your business' data model but it seems that this could be streamlined with a relational system.

Hope this helps,

Cael.