Re: Go to related record automatically if unique ID already exists
I'm doing some work for an insurance company. All the records in the database are identified by a unique policy/agency number. My boss wants to update this database with every new document. When he inputs the policy number, it is flagged as an existing value and the user is asked to input another. Instead, my boss wants the existing record to show up automatically so he can modify it easily.
I'm using FM Pro 10. I'm fairly new to FM, and learning on the go. How do I do this? I've never actually written a script yet, so if that's the way to do it a nudge in the right direction would be useful.
Else, is there some way of using the find screen? Type in number, if exists -> go to record, if not -> creates new record... something like that?