Relational External Content Types

Question

I am creating an external content type in sharepoint 2010

2 tables i have is

1. Voter

2. Status

 

I created an external content type -Voters table

2. external content is from the status table that picks up the voter id.

in sharepoint I want to show names from voter table and status from Status table.

when i right click and say > New Association and select to associate Status able to Voters table, I get error on the first page itself -"Association Properties"

"The related identifier ID is mapped to field VoterCompanyID which is already marked as an identifier of this external content type."

Please advice.

 

Answer 1

Hi,

In SharePoint designer you should select Status external content type->New Association->Click Browse to select related External Content Type->Select Voter ECT->Map an identifier from Voter ECT to the voter id field in the Statues ECT->Click Next

Please take a look at this article BCS External Content Type Associations in SPD

---

Dmitry

Lightning Tools Check out our SharePoint tools and web parts

Answer 2

that is what I was trying to do, but get the error message  -

when i right click and say > New Association and select to associate Status able to Voters table, I get error on the first page itself -"Association Properties"

"The related identifier ID is mapped to field VoterCompanyID which is already marked as an identifier of this external content type."

Please advice.

Answer 3

Are you trying to do the same way as the above article describes?

---

Dmitry

Lightning Tools Check out our SharePoint tools and web parts

Answer 4

Could you please post the Key and Foreign Key columns of the Voter and Status table? That is, on which columns are those tables related?

Answer 5

Definition of voter table =

ID

Voter Name

Definition of Status table

VoterID (FK)

StatusText

when i right click and say > New Association and select to associate Status able to Voters table, I get error on the first page itself -"Association Properties"

"The related identifier ID is mapped to field VoterCompanyID which is already marked as an identifier of this external content type."

 

Answer 6

You can map the related identifier id (which i guess is the ID field in Voter table) to the VoterID(FK) field.

Answer 7

Thats what I am doing.

I created 2 external content types - Status / and Voters

Definition of voter table =

ID

Voter Name

Definition of Status table

VoterID (FK)

StatusText

 

Then I go to Voters External content type > New Association > selected Status as the "Related External Content Types".

below is the error message.

Answer 8

Hi,

If your association goes from Voter to Status you should :

1. Go to Status ECT->right-click on Status table->Select "New Association"
2. Click "Browse" to select related External Content Type->Select Voter ECT->Map an identifier "ID" from Voter ECT to the VoterID field in the Status ECT

---

Dmitry

Lightning Tools Check out our SharePoint tools and web parts

Answer 9

Hi cheerfulwish,

Were you able to resolve your issue?

---

Dmitry

Lightning Tools Check out our SharePoint tools and web parts