SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have 2 tables in my SQL database: Names and Names 2. When I make my individual ECTs for my 2 tables and create an external list in my SharePoint 2010 site, I can see both tables perfectly fine. However, when I make a 3rd ECT and give CRUD capabilities to both tables, I am unable to view both datasets in SharePoint.

What I'm eventually trying to do is crawl both tables via this "3rd ETC" that has CRUD capabilites on both tables. I'm new to SharePoint and am trying different things. I might not need a 3rd ETC for crawling but I'm just wondering.

Please Help! Thanks in advance!

share|improve this question
up vote 0 down vote accepted

In this situation I would suggest creating a view in SQL (assuming you have access to do this) and use that view to create your third ECT for crawling.

share|improve this answer

Your Answer


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.