question

13378467 avatar image
0 Votes"
13378467 asked 13378467 answered

Error Creating Association on External COntent Type

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

https://ibb.co/TBGmfVH109436-ect.png

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


sharepoint-workflow
ect.png (37.7 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@AnujHanda-4267

I want to confirm some information.

Which column in the obChtrMaster table you want to be associated with Chtrobid in Obspeedtech table?

And in the obChtrMaster table, which column you have set as identifier?


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.




0 Votes 0 ·

its the ChtrobID in both tables that are associated. As shown in the diagram

and in obChtrMaster i have made ChtrobId as the identifier.

109895-image.png


0 Votes 0 ·
image.png (8.9 KiB)
EmilyDu-MSFT avatar image
0 Votes"
EmilyDu-MSFT answered EmilyDu-MSFT edited

@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.
110908-capture1.png

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.
110935-capture2.png

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.





capture1.png (26.0 KiB)
capture2.png (8.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

13378467 avatar image
0 Votes"
13378467 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.