AnsweredAssumed Answered

Populate Field if Exists - Help!

Question asked by lobstah on Nov 20, 2017
Latest reply on Nov 21, 2017 by lobstah


Hello all!  I have a field called IDNUM.  On this page, I have two fields as well:  fname and lname.

 

What I'd like it to do, is when the user enters an IDNUM, for it to check the existing records, and if the IDNUM already exists, I want it to populate the fname and lname with the correct information.  If it does NOT exist, then I'd like it to display "This User Does Not Exist" type dialog. 

 

I am sure there is some script that needs to run something like :   if IDNUM exists then fill in FNAME AND LNAME with the correct information.   The issue is I'm not sure exactly what it is I need to look up on the filemaker site to learn how to do this.

 

Thank you so much for your guidance!

Outcomes