Jump to content

open db to specific record


bermaster

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

Recommended Posts

  • Newbies

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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 7344 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
×
×
  • Create New...

Important Information

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