Small and medium business | Business Central, N...

How to update records in sub page from Header page in action

(0) Share

Report

Posted on by KrisMuthy

100

I want update few selected lines in sub page from Header (main page) from action area.

as per the forum suggestion I have created function as global with paremeter as shown below

[External] CallLinesfromCard(krishna : Record "Sales Line")

CurrPage.SETSELECTIONFILTER(krishna);

PSaleslines:=krishna;

MESSAGE('Psaleslines '+FORMAT(krishna.COUNT));

On main page in Action button 'Start' have created code as hwon below

Start - OnAction()

CurrPage.SalesLines.PAGE.CallLinesfromCard(lSalesLine);

//MESSAGE(FORMAT(lSalesLine.COUNT));
IF lSalesLine.FINDSET THEN
BEGIN
REPEAT
lSalesLine."Starting Time":=TIME;
lSalesLine."Salon action":=lSalesLine."Salon action"::Start;
lSalesLine.MODIFY;

UNTIL lSalesLine.NEXT = 0;

END;
CurrPage.UPDATE;

when I see the result at sub page , i can see selected records but in action page I am not getting same records. Instead whole table records are getting update.

Can help me please

Kris

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

Do you want the action on the Header page or on the Subform page, you can also have the action on the Subform,

Was this reply helpful? Yes No
KrisMuthy 100 on at

Like (0)

Report

hi

thank you

you can see the above the action is in header only

this in header page

Start - OnAction()

CurrPage.SalesLines.PAGE.CallLinesfromCard(lSalesLine);

//MESSAGE(FORMAT(lSalesLine.COUNT));
IF lSalesLine.FINDSET THEN
BEGIN
REPEAT
lSalesLine."Starting Time":=TIME;
lSalesLine."Salon action":=lSalesLine."Salon action"::Start;
lSalesLine.MODIFY;

this is in sub page

CurrPage.SETSELECTIONFILTER(krishna);

PSaleslines:=krishna;

MESSAGE('Psaleslines '+FORMAT(krishna.COUNT));

Something is missing. may be variable or parameter

please help

warm regards

kris

Was this reply helpful? Yes No
Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

You are on the header are you are trying to access the subpage selection, I don't believe you can do that. Why don't you add the action on the subform?

Was this reply helpful? Yes No
KrisMuthy 100 on at

Like (0)

Report

yes it is possible

my techi has done, now he is not accessble

you can check the following

www.cloudfronts.com/.../

community.dynamics.com/.../getting-the-specific-record-of-the-line-items

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

Krish,

The solution they suggested is to create a function in the subform page, to retrieve the selected records and then call that function from page 42. You cannot directly access the selection of the subform page selected records.

Can you show the function you have in subform page, how are you passing the variable?

Was this reply helpful? Yes No
KrisMuthy 100 on at

Like (0)

Report

Yes Suresh,

I want the selected records only should updated. one or two. Thats all,

as you said to create action button on sub-page, this is not visible

Warm Regards

Kris

Was this reply helpful? Yes No
KrisMuthy 100 on at

Like (0)

Report

ONE

---------------------------

[External] CallLinesfromCard(krishna : Record "Sales Line")

CurrPage.SETSELECTIONFILTER(krishna);

PSaleslines:=krishna;

MESSAGE('Psaleslines '+FORMAT(krishna.COUNT));

TWO

--------------------------------

[External] CallLinesfromCard1(CrateLinesTable : Record "Sales Line")

CrateLinesTable:=Rec;

CurrPage.SETSELECTIONFILTER(CrateLinesTable);

MESSAGE('Sub page '+FORMAT(CrateLinesTable.COUNT));

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

Kris,

I think what you missing is you need to the variable as VAR when you call the function in the subform to send the variable as reference

Was this reply helpful? Yes No
Suggested answer

divyeshchitte 968 on at

Like (0)

Report

I will suggest you create action on Subpage as Suresh already mentioned.

This will resolve your purpose

Was this reply helpful? Yes No
KrisMuthy 100 on at

Like (0)

Report

Done,

It is simple.

Just create action on header and send value to function in sub page.

in sub page function based action value update lines

CurrPage.SETSELECTIONFILTER(lSalesLine);

IF lSalesLine.FINDSET THEN BEGIN

REPEAT

CASE Actiontype OF
1 :
BEGIN
StatusColor:='StandardAccent';
lSalesLine."Salon action":="Salon action"::Start;
lSalesLine."Starting Time":=TIME;
lSalesLine.MODIFY;
END;
2 :
BEGIN
StatusColor:='Favorable';
lSalesLine."Salon action":="Salon action"::Complete;
lSalesLine."Ending Time":=TIME;
lSalesLine.MODIFY;
END;
3 :
BEGIN
StatusColor:='Ambiguous';
lSalesLine."Salon action":="Salon action"::Paid;
lSalesLine.MODIFY;
END;
ELSE
END;

UNTIL lSalesLine.NEXT = 0;
END;

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to update records in sub page from Header page in action

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

How to update records in sub page from Header page in action

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates