Show student marks with search engine

[Si14]

Dear all:

I have about 20 students. Each has a number and a mark.
I want to design a page with a search box in such a way that when some one enters his/her number in that search box and press "search", the result would be his/her mark.

How can I design this page with front page?

Thank you very much.
Regards

 

[xwb]

Put the students in a database, say access. You just need one table with the student_name, student_id, mark.

Make sure ODBC for Access is on your system. It is if access is installed.

Now use the database wizard in FP to generate the page for you: just follow the instructions.

On the generated code, split it into 2: one for your side and the other for the response.

The query will be something like "SELECT * FROM MARKTABLE WHERE student_id=" & :studentid

That is basically it.

More information on

http://www.microsoftfrontpage.com/content/ARTICLES/dbpower.html