Model-driven app form fields - parent and child relationships

[Sevsep]

Hello everyone,

I wanted to know if I can create a relationship between parent and child elements say for example on a lookup field. If I select parent 'X' than all child 'X' options will appear, and if I select parent 'Y' all of child 'Y's options will appear. 

If this is unclear I will I further elaborate.

Thank you!

[v-xida-msft · Accepted solution]

Hi @Sevsep ,

Could you please share a bit more about your scenario?

Do you want to edit an parent record, then all related child records would be shown up within the LookUp field?

Based on the needs that you mentioned, I think the "Related Records Filtering" option for the LookUp field in your Entity form in classic experience mode could achieve your needs.

The user @ghdunn has faced similar issue with you, please check my response within the following thread:

https://powerusers.microsoft.com/t5/Common-Data-Service-for-Apps/Cascading-filters-to-guide-foreign-...

Also please check and see if the following blog would help in your scenario:

https://www.arbelatech.com/insights/blog/how-to-filter-lookups-without-custom-code-in-dynamics-365-c...

https://carldesouza.com/filtering-lookup-fields-in-dynamics-365/

Best regards,

[Sevsep]

@v-xida-msft 

Perfect thank you!