Drop down search...

[russtic]

I am setting up a teacher gradebook. I have a table with classes in which is linked to another table with pupil details.

e.g. surname, forename, class, grade1, grade2 etc

I have a table which I am using as the frontpage of the database. I want to create a dropdown menu which will be populated from the classes table and then open a new layout poulated with the pupils from that class.

I am not sure where to start if someone could point me to a tutorial or similar to do this I would be very grateful

Thanks

[Matthew F]

This might give you some ideas.

Grade_book.fp7.zip

[russtic]

Thank you - I didn't realise it would be that easy!