AnsweredAssumed Answered

Script to open a record in another database

Question asked by Algo on Sep 16, 2009
Latest reply on May 11, 2010 by cisco1115

Title

Script to open a record in another database

Post

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. 

Outcomes