Script to open a record in another database
I am trying to open a record in another database, based on the value of a field in the first database. (groups/agents if you saw an earlier post about importing).
Open File("Agent Database.fp7")
Perform Find("Agent Database::agentID": =)
Select Window("Agent Database")
It opens the Agent Database but does not perform the find. To even get the Agent Database to show up in the find options I had to add it as a table in the relationships of the Group Database. I was hoping it would prompt the user for a password when it started to perform the find.