By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,921 Members | 1,433 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,921 IT Pros & Developers. It's quick & easy.

Need configuration help

P: n/a
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

Jan 10 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
so you have types of notifications
engineer, owner, productionMgr, etc

and you have groups of people that will receive one or more types of
notifications

so you need
tblNotificationType
notificationTypeID
notificationType

tblEmployee
employeeId
employeeName

tblEmployeeNotification
employeeId
notificationId
that's what I would do

Jan 10 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.