I have a user information database and I want to set up a button activated script so that I can access all the records in a repair log database. Both databases have a field named user and I have a relationship between the two fields established. In the user info database I have a script written to open the repair log database and execute a script that searches that database for all instances of the particular user that was in the field on the user info database. When I press the button on the user info database it opens the repair log database but acts as thought there is no find criteria. I'm using filemaker pro 4.1. I'm sure its something very simple but since I'm somewhat new to FMP I'm at a loss of where to go next. Any suggestions would be great.
Heres the scripts.
****From User Info
Open["maintenece log.fp3"]
Perform Script[External:"maintenence log"]
Exit Script
****From search maintenence log script
Enter find Mode []
Perform Find[]
Set Field["User", "Exact(User, User Info::User Name) or User Info: User Name = User")
Find All
Exit script
