Hi, I'm building a form with only one text field showing and a submit button. The form will only be available to be opened by a staff member and not by members, its a data integrity measure.

The idea is that a staff member opens the form on a tablet. Them members come along and place their member number into the field and submits the form.
The form will have a number of hidden fields where I want the SQL code to populate, based on the member number the member placed into the text field shown on the form.

The outcome is to be able to display a report of the members who attended the event. I'm flexible on how to do this, be it duplication of data by transferring data into a new table or by creating an SQL query from two tables based on t he member number.

So, I'm open to suggestions.

While I've played with SQL a little, I'm by no means past beginner level when it comes to creating the SQL, displaying it on a page and printing it out to a pdf etc.

Any help would be appreciated. I'm open to other means of communication to help with this. Its very much a learning curve for me here.

Appreciate you time.