nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Relationship classes and offline editing

WarrenMedernach

Hello all,

I have a feature class and SQL Server table that I'm trying to relate and make available for offline editing. I was able to successfully get attachments to a feature working, but I'm having some issues trying to get this to function with my SQL table and I'm assuming it is a schema, primary key issue.

From what I've read on relationship classes and preparing data for offline, layers that participate in a relationship must be related using a Global ID field as the primary key. So that said, how can this be accomplished if my data is structured such that I have a point feature class with a point 'name' field that is alpha-numeric, and this field is related to a SQL Server table (1:M) with the same alpha-numeric 'name' field?

Any suggestions would be greatly appreciated.

Warren M

Find more posts tagged with

Accepted answers

RussRoberts

They current version of Collector(10.2.7) does not supported relationship classes. This is coming in our 10.3 update which should be out in late December/early Jan.

All comments

WarrenMedernach

Hi Russell,

As a followup to this question...

At 10.3 Collector will support relationship classes, so does that mean Collector will be able to add additional related records to an existing feature? For example, I have a point feature that has 'instrument readings' (1:M) stored in another table and the relationship class exists between these two classes. Will I be able to add a new 'reading' through the Collector UI?

Thanks

Warren

WarrenMedernach

Awesome, thanks again for the info.

Warren

RussRoberts

While attachments are an example of related information they are much simpler to model and support. Notably they contain no attributes that can be edited nor can they have nested relationships. Collector will be adding support for related data soon, please keep an eye on the blog and news for more information

WarrenMedernach

Thanks for the info Russell.

But... isn't a feature class 'Attachment' simply a relationship class also? And this functions offline? What am I missing?

Warren

RussRoberts

They current version of Collector(10.2.7) does not supported relationship classes. This is coming in our 10.3 update which should be out in late December/early Jan.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.