Best Practice / Clever Idea for Master Employee Designation List
I have a table of employees. Some employees end up being on many notifications. For example, one employee might be the 'Electrical Program Manager', another 'Coatings Program Manager' another maybe 'Repair and Maintenance Director'.
A group of about 5 people tend to be include in many notification emails on several different tables.
What's the best way to easily reference these members on multiple tables, so that in the future if they change, I can just make one change in my employee table and have it change globally?
My initial thought was to have a table called 'Global Lists', with a key field that is a simple number, 1,2,3,4,etc. First, I use summary text fields from my employee table to grab the appropriate employees.
Then, in the future I use Global Lists as a parent to any table that needs the info. On the child table I simply make a formula field = 1 (or 2 etc). That becomes my related field.
I think this works, but also involves a lot of relationships. Any creative way to call on these certain employees without a relationship to every table with notifications?
------------------------------
Mike Tamoush
------------------------------
A group of about 5 people tend to be include in many notification emails on several different tables.
What's the best way to easily reference these members on multiple tables, so that in the future if they change, I can just make one change in my employee table and have it change globally?
My initial thought was to have a table called 'Global Lists', with a key field that is a simple number, 1,2,3,4,etc. First, I use summary text fields from my employee table to grab the appropriate employees.
Then, in the future I use Global Lists as a parent to any table that needs the info. On the child table I simply make a formula field = 1 (or 2 etc). That becomes my related field.
I think this works, but also involves a lot of relationships. Any creative way to call on these certain employees without a relationship to every table with notifications?
------------------------------
Mike Tamoush
------------------------------
