Newbie Script question
I am new to FileMaker and I am having troubles figuring out exactly how scripts work.
What I would like to do is create a unique name identifier, last&first&sequential_number. So the first guy entered named Joe Smith is smithjoe1, the second is smithjoe2.
Here is my thinking my layout has First Name then Last Name being entered. After entering last name, I would like to trigger a script that does this:
Search the database to see if firstlast1 exists
if not, this is a new name, continue on
if it does exist, I would like a pop-up layout listing all the current firstlast records, from this list, I can either choose 1, or create a new record. Either I am not looking in the correct place for the scripts, or what I am seeing is not allowing me to write this type of script.
How can I accomplish this?