Hello,

Is it possible to open a specific database file based on a users entry in a popup list.

i.e. I have a list of people: Barry, Sandy, Gary, each has a seperate database. I have set up a main page with a Popup list of their names once they choose their name I would like to switch them to another database ie. barry.fp5

Thanks

Create a Global field to enter the data. Then create the value list.

The script would look something like this:

If ("gOpen = "Barry"")

Set Field("gOpen","")

Open "Barry.FP5"

(or if you want to have an open script run:

Perform Script (Sub-scripts, External:"Barry.FP5()" [Open Script]

End If

Repeat the If/End If for each file associated with the pop-up list.

On the layout, next to the gOpen field, place a "GO" button to launch the script.

Try this script:

code:

---

If [ UserName = "Barry" ]

Open [ Filename: