topic Re: Proper way to create a Join Relationship in ArcGIS for SharePoint Questions https://community.esri.com/t5/arcgis-for-sharepoint-questions/proper-way-to-create-a-join-relationship/m-p/462804#M1284 <HTML><HEAD></HEAD><BODY><SPAN>This problem was resolved with version 2.1</SPAN></BODY></HTML> Tue, 24 Jan 2012 18:52:40 GMT WalterBeach 2012-01-24T18:52:40Z Proper way to create a Join Relationship https://community.esri.com/t5/arcgis-for-sharepoint-questions/proper-way-to-create-a-join-relationship/m-p/462803#M1283 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>I have data located in a SQL Database that I want to link to my Parcel data.</SPAN><BR /><BR /><SPAN>From there I want to be able to use these new columns for the pop-up and the table that appears below.</SPAN><BR /><BR /><SPAN>How I accomplished this.</SPAN><BR /><BR /><SPAN>SQL Server I created a view for extra data.</SPAN><BR /><BR /><SPAN>In the Parcel layer I created a field that is matched in the SQL database and added matching ID's to link up to the approriate Parcel.&nbsp;&nbsp; I then created a Join between the matching fields.</SPAN><BR /><BR /><SPAN>I then published this as a web service.</SPAN><BR /><BR /><SPAN>Added the published web service to the Sharepoint web part.</SPAN><BR /><BR /><SPAN>If I try to add the Parcel Layer it gives me a join error.</SPAN><BR /><BR /><SPAN>Any help would be appreciated.</SPAN><BR /><BR /><SPAN>Error:</SPAN><BR /><BR /><SPAN>[ATTACH=CONFIG]11400[/ATTACH]</SPAN><BR /><BR /><SPAN>Thank you,</SPAN><BR /><BR /><SPAN>Walter</SPAN></BODY></HTML> Tue, 24 Jan 2012 15:43:00 GMT https://community.esri.com/t5/arcgis-for-sharepoint-questions/proper-way-to-create-a-join-relationship/m-p/462803#M1283 WalterBeach 2012-01-24T15:43:00Z Re: Proper way to create a Join Relationship https://community.esri.com/t5/arcgis-for-sharepoint-questions/proper-way-to-create-a-join-relationship/m-p/462804#M1284 <HTML><HEAD></HEAD><BODY><SPAN>This problem was resolved with version 2.1</SPAN></BODY></HTML> Tue, 24 Jan 2012 18:52:40 GMT https://community.esri.com/t5/arcgis-for-sharepoint-questions/proper-way-to-create-a-join-relationship/m-p/462804#M1284 WalterBeach 2012-01-24T18:52:40Z