Linking Multiple Dropdowns

I have 7 different dropdowns in Visual Composer that I want to link to each other. For example, one dropdown would be on Organization and another on Company Code. If I select a particular Organization, I want Company Code dropdown to only show the Company Codes associated with that Organization. Can someone tell me (and show if possible) what I need to do to make these work? If possible, I don't want to run the report until all 7 dropdowns have been chosen and then hit the submit button to run the report. Thanks!