Page with 2 grids - parent and childs relation

(1) Share

Report

Posted on by Alzack

Hi Community!

I would like to create a page in Business Central that will contain 2 grids (repeaters).

I have 2 tables:
1. headers (Unique identifier “No.”).
2. lines (Relationship to table 1 by field “No.”)

The main data source of the page will be table 1. A separate page whose data source is table 2 will be hooked up as part() to the first page using the

SubPageLink = “No.” = field(“No.”);

I would like the user, after selecting a record, to see in the bottom grid only the records that are linked to the selected record.

I am trying to replicate forms from Dynamics AX/365 with this.

I assume that I could in part() filter out the relevant records using the

SubPageView = filter("No.” = <value “No.” assigned to the page global variable when the header record is selected>)

Unfortunately, I did not find the “After record selection” style event.

Is such a solution even possible in Business Central?

Best Regards!

Categories:

Development

All responses (4)

Answers (0)

Suggested answer

YUN ZHU 70,243 Super User 2024 Season 2 on at

Like (0)

Report

Page with 2 grids - parent and childs relation

Hi, a very simple example

Hope this helps.

Thanks.

ZHU
Suggested answer

Khushbu Rajvi. 2,138 on at

Like (1)

Report

Page with 2 grids - parent and childs relation

Yes, it is possible to create a page in Business Central with two grids (repeaters) linked by a subpage. Set up the main page based on the headers table and use the SubPageLink to connect it to the lines table. The subpage will automatically filter the records based on the selected header due to the SubPageLink, and you can further refine filtering in the OnOpenPage trigger if needed.
Alzack on at

Like (0)

Report

Page with 2 grids - parent and childs relation

Thank you gdrenteria for your reply.

Unfortunately, in the form you are proposing both part() have a relationship directly to a single Bank Acc record. Reconciliation (273) record.

In my case, this parent record will change based on the user selection
gdrenteria 10,067 Most Valuable Professional on at

Like (0)

Report

Page with 2 grids - parent and childs relation

Hi

Maybe this page can give you some ideas?

Best

GR