Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Link fields of same table

Posted on by Microsoft Employee

Good morning everybody,

I'm developing a RDLC report (a Sale) and I'm stuck in linking rows of the same order: I will explain it more in details. I have a particular "function" that for specific articles in an order, will generate two additional rows connected to that line. For instance, let's call the article "article1"; when I insert this in an order, they are generated two rows (artDetails1 and artDetails2) linked to "article1".How could I reference the article? Simply with a field called "linked to line number". In substance, I have written this piece of code:


Tax.RESET;
Tax.SETRANGE(Tax."No.","Sales Line"."No.");
Tax.SETRANGE(Tax."Linked to Line No.","Sales Line"."Line No.");
IF Tax.FIND THEN;


Where "TAX" is the "Record Variable" that refers to Sales Line table. I'm trying to "link to the same table", I think the approach could be correct. Anyway, I cannot see any result.
What I would like to obtain is a report in which for all the lines of the "Sale Order" I have the article with its relative description contained in the rows "artDetails1 and artDetails2) .

Is anyone able to explain me how to proceed?


Thanks in advance

*This post is locked for comments

  • Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Link fields of same table

    Are these creating in same table or another table ?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans