Is there a better way?

[Mickdn]

Have been searching on FM Forums but can't find what I'm after. I'm using a DB with a lot of documents in it and are using a single button to open the relevent document when I want to view it. Currently the script is:

If [Documents::Name = "Doc1"

Open File ["Doc1"]

Else If [Documents::Name = "Doc2"

Open File ["Doc2"]

Else If [Documents::Name = "Doc3"

Open File ["Doc3"]

End If

With 200 plus documents it's going to be a very long script!

Many Thanks

[comment]

The Open File [] script step opens a Filemaker file. Try using the Open URL[] step - this also allows to specify the target file by calculation.

Another option is to use a container field - this too can be a calculation.