1

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

Improve this question
1
  • 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? Commented Mar 22, 2012 at 13:23

1 Answer 1

Reset to default
1

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.

Improve this answer
2
  • Thx for the links but the article does not explain how to link tables after creating External Database. Commented Feb 21, 2012 at 13:59
  • You can then create a lookup columns in your list that links to your external lists Commented Feb 21, 2012 at 14:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.