@wlt_2022 - If each client "knows" what their Client ID number is, I would suggest you use a Text Input control which clients can use to enter their Client ID. This removes the need for a dropdown control and the opportunity for other clients to see other Client IDs.
You can of course use two Text Input controls for Surname and E-mail if you wish. Whichever method you use, you can then use a Lookup function to verify if the Client exists in the Client DB.
Examples below using a variable which returns a boolean:
Set(
varExists,
!IsBlank(
LookUp(
clientdb,
ClientSurname = TextInput1.Text && ClientEmail = TextInput2.Text,
ClientID
)
)
)
Set(
varExists,
!IsBlank(
LookUp(
clientdb,
ClientID = TextInput1.Text,
ClientID
)
)
)
------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.
If you like my response, please give it a Thumbs Up.
Imran-Ami Khan
