web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Insert Record on actio...

Microsoft Dynamics NAV (Archived)

Insert Record on action click one page to another table

(0) Share

Report

Report

Posted on by Community Member

I want to fetch some columns from the selected row and insert it into another tables on action click . I have added one action on list page.

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

I Gusti Made Ari 3,600 on at

Like (1)

Report

You can use SETSELECTIONFILTER to get selected record and then do the insert

docs.microsoft.com/.../setselectionfilter-function

Was this reply helpful? Yes No
Bodhi 558 on at

Like (1)

Report

If only select one raw, define a variable: l_anotherTable link to anther table

Under <XX> - OnAction()

l_anotherTable.RESET;

l_anotherTable.INIT;

CLEAR(l_anotherTable);

l_anotherTable.FIELD := Rec.FIELD;

...

l_anotherTable.INSERT(TRUE);

IF SECTECT MORE THAN ONE LINE, we need to define a variable link to currenct page source table: l_currenctTable

Under <XX> - OnAction()

l_anotherTable.RESET;

l_currenctTable.RESET;

CurrPage.SETSELECTIONFILTER(l_currenctTable);

if l_currenctTable.FINDFIRST THEN

REPEAT

l_anotherTable.INIT;

CLEAR(l_anotherTable);

l_anotherTable.FIELD := l_currenctTable.FIELD;

...

l_anotherTable.INSERT(TRUE);

UNTIL l_currenctTable.NEXT = 0;

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,637 Super User 2025 Season 2 on at

Like (0)

Report

And what did you tried so far?

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans