script: show specified records in related file

[freecolours]

Who can help me with this?

I want to have a script in a databasefile that will open another database and have only show records with the (company)name 'grafidruk'.

Sounds simple(?), but I can't get it to work...

[Anatoli]

In the "another" database create the Find script.

I first db create script, which will call the Find script in another database.

[The Bridge]

If you only want to find that one value, "grafidruk", you can do this:

In your main file, define a calculation field, e.g.

Grafidruk_Constant = "Grafidruk"

Define a relationship from your Main file to your related file, matching Grafidruk_Constant to Company_Name (i.e. the name of the field that holds Company Name)

Call this relationship "Grafidruk Records" or somesuch thing.

Create a script in your Main file with this script step:

Go to Related Records("Grafidruk Records"), Show Only Related

[Keith M. Davie]

Simpler still, once you have the relationship established, place a button on your record layout and designate it to:

Go to Related Records[], Show Only Related

In doing this you will be asked to specify the relationship.