FileMaker Pro 11 - If Statement Script
I'm currently in the process of creating a database that facilitates the recording of patient data at a hospital.
I want to create a script that changes depending on situation (An If statement) I know what I want to do but I don't know how to implement it in FileMaker, I will have a go explaining the desired out come below:
This script will run on a button. When the button is pressed I want the script to:
- Copy the ID field from the current layout
- Go to a new layout
- Enter find mode
- Paste the ID field into the relavent field
- Conduct the Search
- IF the search finds a result (There can only be 2 possible outcomes the way my tables are set up, either there is one entry or there is none), then display the result and exit browse mode.
- ELSE IF Request new record
- End If
This is what I want to implement, however I must be using incorrect syntax as the script is not working for me currently.