Hi Jdraw - lists typed into the arrays in the code modules, the maintenance of the lists is infrequent, perhaps once or twice a year is required. The refresh of the data is regular (several times a week), hence the requirement for the complexity).
Very simplified example would be:
(in reality...
Hi All,
I have a complex master database that is used to refresh the data in multiple smaller databases for groups of users in different business divisions, each one having different populations and a significant number of other factors too numerous to mention.
Simply put, I have numerous...