Query in VB

Hi guys, here is my question.

I have a database in Visual Basic 6.

It is based on something i am working on called medical records.

There are two tables. One called patient, and the other called staff, (a doctor).

Patient holds patientID, staffID, name and surname.
Staff table holds staffID, staffname and staffsurname.

What i want to be able to do is to enter a staffID number (in a searchbox), like S500, and for all of S500's patients to be displayed on screen, either in a grid or report. (prefer grid).

I have no idea on how to do any of this.

I have read a few books but most of them dont make any sense to me!

I am a complete novice at VB, so i would appreciate it if you could explain each step clearly - I am a dumb blonde, lol.

Many thanks for your help in advance!

Danni.

LOL - you're essentially asking: Teach me to program.
Read some more books.
Read some of the many online tutorials on database connections, recordset, querying.
You really need to take a few more steps before anyone can help you.

Things you should learn how to do:
Setup a DB connection (using ADO)
Create a recordset (i.e. perfrom a query and return results)
Loop through a recordset

You can use ADO to solve the problem. You'd better look for some book about ADO,or just use MSDN.