AnsweredAssumed Answered

Newbie Script question

Question asked by BLACH3L on Feb 21, 2010
Latest reply on Feb 21, 2010 by RickWhitelaw


Newbie Script question


Hi all,


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?