Showing Matching Order No in another Database

[clmoss]

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.

[Ocean West]

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.)