Hi ,

I have 2 external lists ,"Employee" and "Department" .I want  "Employee ID" column from "Employee" table to act as a primary key and want to refer that column in "Department" list like the "External Data Column".Can we have a "External Data" Column in external

Hi Aditya,

According to your post, my understanding is that you want to create an External list with lookup column.

External list does not support to create lookup columns.

Alternatively, you can associate two or more external lists when you define an external content type.

For more information, you can refer to:

Differences between native and external lists

How to: Add an Association between Two Database Table-Based External Content Types

Viewing Associations in the User Interface

Thanks,

Wendy