Unanswered

Relationships and Editable Subgrid

(0) Share

Report

Posted on by MikeBlairTP

149

I have two custom tables, Invoices and Invoice Line Items. Both primary columns is the Invoice Number. What I want to achieve is to show the Invoice Line Items in a editable subgrid when the invoice is opened.

I have created a one to many relationship on the invoice table

When I add the subgrid to the page it returns all invoice line items from the table, not the expected items for that particular invoice. What step am I missing here?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

gulshankhurana 1,397 Moderator on at

Like (2)

Report

Hi @MikeBlairTP

I'm not in front of the computer so can't give precise information with screenshot but, from memory, I can try.
Please open the Invoice form, highlight/select the Invoice Line Items subgrid and, in the properties pane that appears on the right side, you'd be able to see the option for showing only related records.

Kind regards
Gulshan

Was this reply helpful? Yes No
gulshankhurana 1,397 Moderator on at

Like (2)

Report

screenshot attached this time. I have used example of one account having many contacts but showing only related contacts on the form. Contact subgrid on Account form is highlighted and the option to show only related record is checked on the right hand side property pane.

I hope this information helps. Please give it a thumbs up if you appreciate my efforts and mark it as a solution if it helps resolve your query.

Kind regards
Gulshan

Was this reply helpful? Yes No