Jump to content

Finding from one DB to Another


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

Recommended Posts

ok. Lemme say now I'm sorry if this is simple.. I'm just not good with this stuff smile.gif

I have two databases ,DB1 and DB2, and DB2 has a relationship to DB1 with the 'Company Name' field. I want to perform a find on DB2 based on the value in the "Company Name" field of DB1. But I want to do it from a form on DB1.

Geeze.. did that make sense?

ok. I want to hit a button on db1 that will bring me to db2 and show just the records with the "Company Name" that I was at in DB1 when I hit the button.

thanks alot. if I can help clarify this I'd be happy to. Thanks again!

Version: v6.x

Platform: Mac OS X Panther

Link to comment
Share on other sites

Create a relationship from db1 to db2, if you don't have one already.

In db1 create a script

Go to Related Record [show, Company Name]

Perform Script [External]

in db2 create a script

Go to Layout ["theOneYouWant"]

Toggle Window [Maximize]

in the Perform Script step in db1 select the script from db2.

Link to comment
Share on other sites

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