Hi!
I have a file with 3 tabs - The first tab (template) has a drop-down based on the funds list from tab 2 (Funds) that has an external oledb connection and updates automatically when the file is opened.
My 3rd tab has several different IDs related to each fund in tab 2 and also has an external connection and updates automatically.
What I need and can't figure out how to do is in my main tab (template) create a drop-down based on the fund selected in the first drop-down that pulls the IDs that are related to that specific fund based on list on tab 3 (ID).
I'm attaching the file to make it easier to understand. I also wrote notes next to each tab to explain a little better.
Bookmarks