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.
Hi @Adham-Nawito ,
Is this what I suggested with the last recommendation or did you do something different? If it is, can you please mark as a solution, if not you can mark yours as the 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
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...
@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
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
@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.
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.
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
Hi @Adham-Nawito ,
Few things here:
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?
stampcoin
15
ankit_singhal
11
Super User 2025 Season 1
mmbr1606
9
Super User 2025 Season 1