I have a mySQL database with a number of tables. I would like to set the mastersource with one of three other tables depending on a user entry.
I would like to do it in such a way that I don't have to modify the code if I add a table to database.
I am leaning toward DAC for mySql and the database component has a gettablenames which will give me the list of tables by name.
How would I assign the mastersource for each table in the stringlist?