Hi All,

I have a form which has these fields:


STUDENT ID, NAME, DATE, CLASS TYPE.

My question is:
There are two things that I'm trying to have with no success till now:
1. Once the user enters the ID, I would like the NAME to be filled up automatically.
2. In other words I want to have a validation that the entered ID is a valid one (means already exists in the STUDENTS table)

How do I achive these two things?

Thanks,
Dani.