what would you do if more than one record is found ? (Very probable, if you have home phone number of both husband and wife)
When you have a script searching and you are not certain about obtaining a non-empty found set, you want to trap errors, so your script starts with Set Error Capture [on]. You do your find and
If [ get( lastError ) ] --> go to "another" layout // this solves your second problem
go to layout [normal layout] // this almost solves your first problem.
i must confess i don't know what your answer means. i expect that there will be multiple records found but thats ok, i just need to go to another layout if a phone number is found
as for not finding any records, i expect to use the if statement to go to the first layout but i don't know how to word it
Basically something like this
If [Get ( FoundCount ) = 0]
Go to Layout ["Number not found"]
Go to Layout ["Number found"]
So would I put this string in the script or in a calculation for the field?