[IMail Forum] MSSQL and Views

[Lostboy]

Ok, I know I am going to sound like an idiot but, How in Imail do I set the Domain to look at a View instead of a Table? I have had IMail Make a database just to make sure I had rights setup in SQL.  But when I set the Table name in IMail All the happy users go away :/  The view is pulling USERNAM PASSWORD and FULLNAME out of another table. Or is there a easy way to create a table that links the USERNAME = LOGINNAME and so forth. Sorry SQL N00B   Any help would be great!   Ben Holston