Select to view content in your preferred language

Proper way to create a Join Relationship

1639
1
01-24-2012 07:43 AM
WalterBeach
Emerging Contributor
Hello,

I have data located in a SQL Database that I want to link to my Parcel data.

From there I want to be able to use these new columns for the pop-up and the table that appears below.

How I accomplished this.

SQL Server I created a view for extra data.

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.   I then created a Join between the matching fields.

I then published this as a web service.

Added the published web service to the Sharepoint web part.

If I try to add the Parcel Layer it gives me a join error.

Any help would be appreciated.

Error:

[ATTACH=CONFIG]11400[/ATTACH]

Thank you,

Walter
0 Kudos
1 Reply
WalterBeach
Emerging Contributor
This problem was resolved with version 2.1
0 Kudos