Microsoft Access query problem

[Klo]

Hi,

Not sure if this was the right place to ask this, but I'll go ahead anyway

This isn't so much a problem with the software as a lack of my skills within the program to make it do what I want.
I am creating a room booking database for a school ( A2 level coursework). I have a table of all the teachers names along with an autonumber primary key. This is related to a teachers field in the booking table as OLE object so I can just use a drop down box to select it.

My problem is that when I run a query searching for all the bookings a certain teacher has made, it doesn't work off the teachers name, but off the autonumber (eg, 6). Obviously, this isn't very useful, but whatever I do I can't get it to run off the teachers name, only on the primary key. I even tried deleting the primary key altogether, but that buggered the entire system up.

Does anyone know of a solution for this?
Thanks

 

[Klo]

what are you using to search though the table and display the results, some kind of interface within access?

I'm just creating a standard parameter query so I can type in the teachers name I want to find all the bookings for. It works, apart from the fact that I have to type in the autonumber the teacher is, rather than their actual name.

 

[Klo]

Hehe, you lucky person! It does indeed, but I'm not sure how to find the actual sql, I think you can type it in under search criteria, but not sure. All I can find is stuff about Visual Basic , which is a bit too complicated for a A level piece of work!!