cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Andreas_S1
Frequent Visitor

what column type to reference unique IDs?

Hello, 

surely a beginner's question, but I cannot find an answer anywhere. 

I want to make a table column (in table A) that references another table's (B which is a standard table) unique id.  This can be seen as a 1:1 relationship. 

There is no column type for Unique IDs selectable. What has to be used? Text ??

Or has it to be done via 1:N relations? 

thanks

Andreas

2 REPLIES 2
Fubar
Solution Sage
Solution Sage

There is no 1:1 relationship in DataVerse.  1:N relationships are defined by creating a field that is a Lookup (selecting the Parent entity as its type) on the Child entity (behind the scenes DataVerse use the Parent records internal GUID to set the foreign key - the Lookup - on the child).

 

You can mimic a 1:1 by doing a 1:N (lookup on Child) and then another N:1 (on the Parent), then when Child is created also populate the Lookup on the Parent (usually via Workflow or a Plugin), you can also enforce the 1:1 e.g. Workflow or Plugin that fails the create of a Child if the Parent's lookup already contains data (there is also more that can be done - but this is probably enough to get started).

rampprakash
Super User
Super User

Hi @Andreas_S1 

 

There is no standard behavior called 1:1.

 

If you are referencing with lookup then it is called 1:N Relationship that will be mapped with GUID values

 

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA

Blog : https://microsoftcrmtechie.blogspot.com

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (2,159)