Navigate to record based on multiple fields (1 Viewer)

cmray58

Registered User.
Local time
Today, 13:42
Joined
Mar 24, 2014
Messages
70
I'm building an assessment tool and would like the end-user to search for the client before proceeding with the assessment to see if the client has already been assessed. The client should be searched by last name and DOB or last, DOB, and first.

If the client exists, the form navigates to the record.
If the client doesn't exist, the form creates a new record with the info that was provided in the search.

Everything is in one table.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 13:42
Joined
Oct 29, 2018
Messages
21,467
Hi. You might try looking in the UA Code Archive for some possible examples where you could get an idea on how to do this.
 

cmray58

Registered User.
Local time
Today, 13:42
Joined
Mar 24, 2014
Messages
70
Thank you!
 

theDBguy

I’m here to help
Staff member
Local time
Today, 13:42
Joined
Oct 29, 2018
Messages
21,467
You're welcome. Let us know if you don't find anything useful or if you get stuck trying to implement what you found. Good luck!
 

Users who are viewing this thread

Top Bottom