Entity Connections

[dmann622]

Hello all,

I am trying to understand how entities connect in order to connect them together as records. I essentially want to have a Record "A" that has the blue lookup field that connects to Record "B" in a different entity. Then again from Record "B" I want to be able to click on the lookup field that connects to Record "C", again another entity, and so on. 

Thank you for your help.

[v-yutliu-msft · Accepted solution]

Hi @dmann622 ,

Firstly, yes, you could use a lookup field in entity A to filter records in entity B.

Secondly, look up field could only connect with two entities with 1:M relationship.

So based on your demands, you need to create this kind relationship:

1)entity A to entity B :    1:M relationship

2)entity B to entity C:     1:M relationship

3)entity C to entity D   .....

Please note that: after you create 1:M relationship successfully, the lookup field will generate automatically in the "Many" entity.

(entity B has a lookup field that looks up to entity A,

entity C has a lookup field that looks up to entity B .....)

You could use this way to filter one by one:   (for example, I have 4 entities:  A B C D)

1)insert 4 drop downs

2)set drop down 1's Items:

entity A

set drop down 2's Items:

Filter(entity B,lookup field=drop down 1.Selected)

set drop down 3's Items:

Filter(entity C,lookup field=drop down 2.Selected)

set drop down 4's Items:

Filter(entity D,lookup field=drop down 3.Selected)

Then, entity B will be filtered based on selection of entity A.

Entity C will be filtered based on selection of entity B.

Entity D will be filtered based on selection of entity C,......

Here's a doc about relationship in CDS for your reference:

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/create-edit-1n-relationships-po...

Best regards,