Finding records with a combobox

[d²c]

Hello,

I currently have two tables, one for students and one for classes.

I would like to create a dropdown box on my students layout. When an option (class from a student) is clicked, then the layout from classes should appear with the correct portal. Can somebody help me?

I included a sample file for your convenience.

Thanks in advance,

regards,

D2C

classroom.zip

[Raybaudi]

Hi,

make the option a button that have to

Go to Related Record [show only related records; From table: "classes"; Using layout: "classes"(classes)]

[d²c]

Thank you very much for your help, I used the "check" example from another post in this forum (also from you).