Error Creating Association on External COntent Type

Question

i am trying to create an association and getting an error about identified already marked

https://ibb.co/TBGmfVH![109436-ect.png][1]

Below is the scenario, we are trying to replicate using ECT’s in Sharepoint , We have the ObSpeedTech table in SQL server which we would like ability to maintain this table using SharePoint list.

When I create these External Content type and lists It works fine. No issues.

What we are looking to do is show the ChtrobNm and Tech Name from the 2 related tables in the form which seems to be a problem.
To Accomplish this task I have to tried to use Associations

I am guessing its complain that the Chtrobid in Obspeedtech is already marked as an identifier so it can’t create the association ?
I tried only keeping TechSrc as an identified and then create the association for the ChtrobId and TechID, in that case the BDCidentity generated is based on Techsrc which is inaccurate..

is there a way to do this on sharepoint 2013

Answer 1

@AnujHanda-4267

Per my test, we cannot create association between two identifiers.

As a workaround, I suggest you create a ID column filled in with same values in the Chtrobid column in the obChtrMaster table.

1.Select obChtrMaster content type -> Operations Designer View -> Choose obChtrMaster table -> New Association -> Choose ID column.

2.Go to a new web part page -> Add Business Date list by using Obspeedtech table -> Add Business Date related list by using obChtrMaster table.

Here's a reference video for you.
https://www.youtube.com/watch?v=Hg-FWy2kdW8

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

creating and ID Column in the obChtrMaster doesnt work as i cant associate the obChtrMaster.ID with Obspeedtech.Chtrobid,

because Obspeedtech.Chtrobid is an identifier

for your suggestion to work i would have to create the ID column in the Obspeedtech table

so the structure of the obspeedttech table would be

Chtrobid
Techid
TechSrc

Tech_ID
Chtrob_ID

i tried it this the view that didnt work, will have to create physical columns