Create a list Lookup using site pages

Good day Jose,

In your Source list field you are pointing the list to look at the sitepages which will not work.  You have to point this lookup list to the list that is being displayed on the page.  Although you can see the department list on the department.aspx page, it is probably just a webpart added that is pointing to the real department list.  In the source list you should be selecting the department list.  

In the source view field you should specify only the view name that was created on the list...usually there is an all items but you can create your own view and use that but without the .aspx at the end. And finally I see that you specified the BaseDescription which is correct...just check the spelling...I'm still on Sharepoint 2010 and I have to have capitals where there are capitals and lower case where it is lower case and the actual column name seems to baseDescription.   

If you are still not coming right, please send us a screenshot of the all site content lists as well as the department list's settings. 

Let me know. 

Good day Jose, 

This is still creating an external datalist on the page. In the example he is pulling in the Employee list on the employeedetail page. 

Where you are setting up your lookup droplist action to give a lost, you should specify the table on the page as the sourcelsit.  Open the department page and click on the heading of the department  list. This should open the list that you want to display in the source view list. 

I solved the problem by installing sharepoint server and created a list through sharepoint design using external content types