how can I, based on a field in a current record, open another database to a record based on the field from the original database

example: I have a field called "systemid" in database1, and there is a field called "recordid" in database2, how can I, from database1, open database2 to where database2.recordid = database1.systemid?

In database 2, have a script:

enter find mode

paste (recordid)

perform find

refresh window (bring to front)

In database 1 have a script:

copy (systemid)

perform script (the script in database 2)

toggle window (hide)

That's it.

-Stanley

Thanks!!!

Or create a relationship, db2_sysrec, from systemid to recordid, and have a script

Go to Related Record [show, db2_sysrec]

Perform Script [External, db2] {maximize and halt}

In db2, 'maximize and halt' script

Go to Layout [desiredLayout]

Toggle Window [Maximize]

Halt Script