I'm attempting to use a Display Form to show the data from an SQL table. I need to be able to display only the data with a specific job number and I would like to be able to search this job number in a text input. For example:
JOB First Name Last Name
1 John Smith
2 Peter Smith
So in the Item properties of my Display Form I put the formula:
This gives an error, but if I put:
I get the proper information. But obviously can't change the job number while using the app.
How can I make this work by searching the job number by means of a text input or other input?