displaying related table data in a combo box

[nichclark]

I have set up a relationship between two table and have enforced the referencial integrity. How can I create combo box's for each table and have the user select one record in a table and then only show the related records in the other combo box.

I hope this makes sense

 

[Oldsoftboss]

Search for cascading combo boxes if this doesn't help. I downloaded and saved this demo years ago.

Dave