How to display columns in a parent form from child table dataverse

[Adham-Nawito]

I have Parent-Child tables, where the lookup column is inside Parent. (both tables have ID, Name .. IDs are PK).
I'm trying to create a form from the Parent table, where this form I can choose Name from Child.

What  I can display so far in the form, is the lookup column which is the child ID, but It's not human-readable and doesn't mean anything to my user, they need to see the Name instead of the ID.

I tried to add a new component "form" to my Parent form and edit this newly added form and add the Name to it to display both ID and Name. 

What I get after the previous step, 2 created components instead of one

 the default one, is related to lookup column, the other form component is the one that I added manually and the one I want it to be displayed.

But what I get is always showing this thing

 and whenever I remove the "Form Component Control", it displays the lookup column 😞

Any thoughts about how to achieve this and display not just lookup column in parent form, but display more than 1 column from child into parent form.

[a33ik]

If you want to show the data from child records you can use the subgrids. Because for 1 parent there might be from 0 to infinity child records - which one of children records should be shown?

[dpoggemann]

Hi @Adham-Nawito ,

Few things here:

1. You mentioned the "lookup column is inside parent".  To setup a Parent / Child relationship in Dataverse, you should be adding a Lookup field to the Parent table as a column on the Child table.  This is specifically a field type of Lookup and you select the table.  There is no ability to select a different column etc. when setting up this relationship
2. You can display a sub-grid on the main Parent form to display the list of child records (https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/form-designer-add-configure-sub...) on the parent form. 
3. If you want to select a primary Child entity (example for an Account, who is my Primary Contact) you can add a lookup on the Parent table to the Child table and then have this Lookup column on the form filtered to the child table with related records (https://blog.magnetismsolutions.com/blog/dominicjarvis/2017/10/19/how-to-filter-lookups-by-related-r...) 
4.  

[Adham-Nawito]

But isn't subgrids are used for table display kinda, not as form display. 
What I mean, it's used for displaying the data, editing the data in the table, not for creating a new record for example as it's done with the form

[dpoggemann]

Hi @Adham-Nawito ,

If you are displaying the child data in the form in a sub-grid, there is the ability to add a new child record from that grid.  Depending how you configure this it could launch the form as a popup (quick entry form) or navigate to the full form.

[Adham-Nawito]

@dpoggemann Can I display in the form any data from the child table (not just the lookup column)?
I mean if I have relation M:1 where it's connected by ID as FK, but I don't want to display ID column in the parent, but instead I want to display Name of a person for example. Is this doable or just the lookup column can be displayed in edit form nothing more than that ?

My use case:
edit form

I've projects table that have lookup fields to other tables (writing script, locale, ...).
Projects table, have lookup fields to the other tables inside it, (wiritng_script_id, locale_id,...),
and I'm displaying them inside the edit form when u select a record from projects.

Is there anyway to display Names from other tables (as the consists of ID & Name) rather than ID as IDs are not user friendly to be selected and user shouldn't see them I want him to select something like "English" in locale, instead of "ID" 1.

[dpoggemann]

Hi @Adham-Nawito 

You can display the parent fields from the related table (i.e. from the Lookup column) on the form for the child table by using a "Quick View Form" - https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/create-edit-quick-view-forms 

[Adham-Nawito]

@dpoggemann Quick form is not allowing me to edit any of the fields, I want them to be editable.
or I'm missing something here?

Like in this image, as you can see while searching for an owner it shows me ID and Name which is totally fine.
But on final displayment you can see that It was only ID, I just want to get the Name instead of the ID in the same area

[dpoggemann]

Hi @Adham-Nawito 

Sorry, didn't know you are looking to edit, missed that...  If you want to embed a form to edit the parent fields, please check out the following:  https://www.ameyholden.com/articles/quick-view-forms-with-edit-form-component-control 

Let me know if this is not what you are looking for...

[Adham-Nawito · Accepted solution]

I solved the issue by adding a from component next to my lookup fields, where this form component maps which column I want to display and made the field as read-only