Answered

Unable to create relationship to Address table

(1) Share

Report

Posted on by haoest

hello,

In my new solution, I have added an existing "Address" table from out-of-box tables. In addition, I created my own custom "Office" table. In this Office table I want to add a lookup field to Address table to establish the relationship. But When I try to add a new Lookup column, the Related Table drop down list wouldn't give Address table as an option. Same if I go to New > Relationship > Many to one screen, Address table would not show up in the drop down list either.

What's wrong?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Parvez Ghumra 1,579 Moderator on at

Like (1)

Report

@haoest I get the same behaviour in my environment. My guess is that, because it's a special type of table with some built in behaviour, customisations to it of certain types are restricted. Therefore, you will not be able to create this relationship.

As a workaround, you can create a set of custom Address columns on your custom Office table (as you were planning to create a single Lookup to target the Address table.

Was this reply helpful? Yes No
haoest 58 on at

Like (0)

Report

@parvezghumra thank you for helping.

I poked around the standard tables, and I find that Account and Contact tables are able to form relationship with Address table... I think there's a way, just a matter of finding that needle in the haystack of options.

Was this reply helpful? Yes No
Verified answer

a33ik 3,306 Most Valuable Professional on at

Like (3)

Report

Hello,

I haven't played with Address (customeraddress) table for awhile.

As far as I remember it's not possible to create a custom relationship (any way 1-N or N-1) with customeraddress table and there is a flag in Entity Metadata that points to this:

So, I'm afraid you won't be able to do it.

Was this reply helpful? Yes No