As our database runs, there are occasions where someone in the
organization should be notified about significant events, such as
automatically advising the Design Engineer when a new part has been
added or the Production Manager when some other event has happened.
For these notes I use a little Instant Messaging system I built into
our database, that I call TMail. It allows quick messages to be sent
around from person to person, without having to leave the database.
    As this same code (but different backend) is running in three
different companies, I cannot, should not, hardwire the IDs of these
key people.  I have a [Configuration] Table where, among other things,
I have my own Employee ID entered as [Super User ID] for system level
things that happen that I would like to be informed about.
    My question: Is the most elegant solution to add fields to the
[Configuration] Table like [Engineer ID], [Owner ID], [Production
Manager ID], et cetera, so that from company to company the relevant
Employee IDs could be entered and the proper people could be notified?
    Even if I used normal Email, I would still need to identify the
appropriate person in each company to receive the mail.  How have you
handled this situation?
Thanks,
Hank Reed