Announcements
I have two existing tables and I want to build a view. From what I understand, I have to build a relationship between the two tables before I can create a view that uses both tables. When I create a relationship, the interface does not ask me which fields I want to be part of the relationship. This does not make sense to me. I am an old SQL guy and this does not make sense.
What kind of relationship are you trying to add? Is it safe to assume it's N-N? In this case, fields would be assigned by PK fields of both entities.
one to many.
When you create a relationship UI asks you to provide a related table and the column in the related table.
You can check the following post - https://www.linkedin.com/pulse/relationships-types-behaviors-dataverse-kumar-manish-csm-pmp-/
Unlike SQL, Dataverse manages the PK and FK.
The PK is a system generated GUID that is held in a column with the same logical schema name as the Table but with a suffix of "id" e.g. for a table with schema "new_mytable" the PK will be in "new_mytableid" (You can extend this by creating Alternate Keys)
The FK is a little bit more difficult conceptually - the FK is always a GUID and the only way you can create a field of that type GUID is to create a field of type Lookup (and doing so will automatically create a FK).
Also, whilst the FK linkage is the the GUID, the Lookup on the Child will display the Primary Name Column value from the parent.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 505
WarrenBelz 502 Most Valuable Professional
Haque 324
