I have a simple dataverse table (tbl_Vendor) withs vendor information.
I have a screen that has:
- A galley form (galVendor) for vendor selection
- A Vendor Info display form (dispVendor)
I recently added another table (tbl_Comment) to hold comments concerning the vendors in tbl_Vendor.
This table (tbl_Comment) has a relationship with the vendor table (tbl_Vendor) through the addition of a lookup column (lu_Vendor) in the Comment table that allows you to select a vendor record.
I want to add a new form (frmComment) to the screen, that will display any existing comment for the vendor selected in the gallery. But I cannot figure out how to setup the form (frmComment) to display all comments for that selected vendor.
if you are using a model driven app the best way is to use your vendor form and add a sub grid control that is using the related comments. Or create a new form on vendor table and do the same thing.
Hello, @DigitalMT-02, form control can only display one record of a table. If you want to display all comments from the comment table, I suggest you use either a gallery or a table control. The items property of the control should be GalleryName.Selected.lu_Vendor << know that you don't need a Filter function to retrieve the related child records when you do have relationship in place.
If my reply helped you, please give a 👍 If it solved your issue, please give a 👍 & accept it as the Solution to help other community members find it more.
Visit my Blog: ahmedsalih.blog
Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos
mmbr1606
22
Super User 2025 Season 1
stampcoin
17
ankit_singhal
11
Super User 2025 Season 1