Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

How can I link two tables from an External SQL server database to a SharePoint list and also send emails from it.

share|improve this question
    
Could you add more details about what you mean regarding "send emails from it?" Are you talking about alerts or work flow or something else? –  Robert Kaucher Mar 22 '12 at 13:23
add comment

1 Answer

up vote 1 down vote accepted

You need to create an External List (http://blogs.msdn.com/b/vssharepointtoolsblog/archive/2010/04/27/walkthrough-of-creating-a-sharepoint-2010-external-list-using-visual-studio-2010.aspx). But if you are talking about making it email enabled (http://technet.microsoft.com/en-us/sharepoint/Video/ff679958) I think it's not supported for external lists.

share|improve this answer
    
Thx for the links but the article does not explain how to link tables after creating External Database. –  saumilm Feb 21 '12 at 13:59
    
You can then create a lookup columns in your list that links to your external lists –  Alex Boev Feb 21 '12 at 14:42
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.