Accounts
------------------
AccountID PK
Name
AccountRepID FK
Users
------------------
UserID PK
Name
Username
Password
AccountID FK
UserType
The Users table will be used for logins to the system. In the Users table
will be
SysAdmins system administrators
AccountReps account sales representatives
AccountOwners Account owners
AccountUsers Acount editors
I have a 1:1 relationship from Accounts to sales reps in the Users. But
I'd also like a many:1 relationship from Users who either own accounts or
are editors of those accounts. I can't have both relationships.
How best to approach this?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
