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!