I've created a database containing student file information (ID, missing items) and would like students to search by ID rather than calling.
I'd prefare if the table is be hidden and all what the page has is a text box (to enter ID) and a search botton.
Missing items are as follow (copy of passport, copy of Highschool cert, and a photograph)
desired output messages are as follow
1. Yes you do have a complete file, Thank You
2. You do have a file, but it's missing (one or more of the missing items described above)
3. Sorry, you don't have a file. click here to download the form