Newbies bermaster Posted February 19, 2004 Newbies Share Posted February 19, 2004 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 More sharing options...
stanley Posted February 19, 2004 Share Posted February 19, 2004 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 More sharing options...
Newbies bermaster Posted February 19, 2004 Author Newbies Share Posted February 19, 2004 Thanks!!! Link to comment Share on other sites More sharing options...
-Queue- Posted February 19, 2004 Share Posted February 19, 2004 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now