Jump to content

Showing Matching Order No in another Database


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

Recommended Posts

I have 2 databases both with an 'Order Number' field. What I am trying to achieve is this:

On the first database,there maybe a record with '003' in the 'Order Number' field. When a button is pressed, which is linked to a script, it will open the second database, bring it to the front and locate the record with the order number of '003'.

I have tried various scripts but none are working. I am guessing that I need a script on the first db attached to a button that will open the second db and run a script from from the second db. Somehow get the value of 'Order Number' from the first db and insert it into a 'Find'.Or am I way off?

Thanks, for any help.

Link to comment
Share on other sites

Create a relationship in the first database, to the second database.

Order number = Order number

You then create a script that "goes to related records" "showing only related records" then peform an external script step and assign it to a pre defined script in the 2nd database that goes to the layout you need. (You need to create the script in the 2nd database first.)

Link to comment
Share on other sites

This topic is 7306 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.