Single Field Dynamic Drop Down

Single Field Dynamic Drop Down

I have three Reports(Tables), One is Manufactures that has a one to many relationship to Consoles then i have Games. I have a form for Games, i want to select the manufactures using the dropdown then it clears the drop down and finds consoles that relates to the selected manufacture using the one to many relationship. I would like to use a Deluge script no sub forms.