Jump to content

Linking 3 database files


This topic is 7792 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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.

Link to comment
Share on other sites

  • 2 weeks later...

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.

Link to comment
Share on other sites

This topic is 7792 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.