AnsweredAssumed Answered

How to create an SDE view with a 1 to many relationship?

Question asked by jsn on Dec 29, 2016
Latest reply on Jan 3, 2017 by jsn

Hello everyone,

 

Is there a way to create an SDE view using a FC and a table, where for each record in the FC there are 0 or several records in the table.

 

I tried to create a SDE View i arcCatalog 10.2 with a query similar to this one:

select FC.Code, Table.DateEvent from FC, Table where FC.Code  = Table.Code

 

and when I add the SDE view in ArcMap it asks for an field that is a unique ID, otherwise the SDe View can not be shown.

 

How can I create a field that is an unique id.

 

Thanks

Outcomes