Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jason@rothsteinmemsic.com
Starting Member
1 Post |
 Posted - 2001-08-13 : 13:36:42
|
| I have a slight problem I hope someone can help me work out. ASP pages on Win2K server with SQL Server 2000 DB.I am building an Intranet, and every employee has a login and password(stored in an employees tables)I am now going to be adding some functionality for clients so thatthey can login to a part of the intranet to view thier schedules,estimates etc...So I was thinking 'sure thats easy, no problem, just add a usernameand password to the clients table' and I'm sure I could figure out howto check if the login is a client or employee.But heres the catch!! In one section of the intranet there will be amessage forum, so employees and clients can post messages back andforth. So in a message table it would be employeeID, message, date.But then when the client posts a message it would need to be clientID,message, date. And what would happen if a clientID and employeeID werethe same number???A work around I thought of would be to start the clientID numbering atlike 10000 or so, but what if one day down the road the company hasmore than 10000 employees.Any one else had this problem? Any solutions??Please help...Thanks-Jason |
|
|
|
|
|
Database Design: Login and Passwords from 2 tables