** How can I filter a dropdown based on a table? **

You will need to create a [[:how:globalappsettings|Global Application Settings table]].