combo boxes is form

[panosD]

i work for a company which sets up advertisements to play in different venues. i have set up a database of all the different venues and the sponsors which show ads at these venues. there is a different set of ads to each venue and about 180 ads all up.

what i want to do is set up a form that lets you pick a venue from a drop down list to show you which sponsors have ads there in another drop-down list, which also lets you add sponsors if you need to. and when you add the sponsors, it adds them to the sponsors table. i need to do the same with a drop down list of sposors which gives you a drop down list of venues you can add to.

if anyone can help me with this, or maybe give me a better way of setting it out, your help owuld be greatly appreciated

thanks
Panos