I have 2 databases, one which hosts employee information called empInfo.
And the second hosts employee times empTime.

Now I am also adding in the ability to leave users a Message so when they punch in they get a message. Now this is easy, as I could just add in a message field to the empInfo.

But I need to be able to archive the messages, and not only that be able to leave a message to a user called ALL (which would be a global message not dependant on a user).

So I would need a new table call this one empMessage.
Now it has to have a link to the primary table (empInfo) as it should only have messages to users that exist(so refferentiall integrity), but ALL does not exist (unless i make a generic user ALL which may be the solution).

So how do I make sure I have ONLY users from the empInfo table yet be able to have global messages?

I hope this makes sense.

My solution is to create a ALL user in the empinfo table, and then when displaying the message query for all, and do individual queries for the other users.

Thanks!