web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Tables relationship

(0) ShareShare
ReportReport
Posted on by 104

Hello,

How do I know what the relationship of one table to another is in BC? For example Sales Invoice Line with Item.

Thanks.

I have the same question (0)
  • Suggested answer
    MahGah Profile Picture
    15,529 on at

    Hi

    I normally use the following web site

    https://dynamicsdocs.com/nav/2018/w1/

  • Michel Chacaliaza Profile Picture
    104 on at

    Thank you very much.

  • Suggested answer
    Steven Renders Profile Picture
    5,672 Moderator on at

    You can't know it, because it's not documented. However, please vote for this idea:

    experience.dynamics.com/.../

    Tools like this:  https://dynamicsdocs.com/.  or Statical (https://www.stati-cal.com/) have this built in. But I believe this should be available in the docs.

    Some small bits and pieces are already available here:  docs.microsoft.com/.../design-details-application-design.

  • Suggested answer
    Alex A Profile Picture
    2,924 on at

    Hello Michel,

    You can usually figure it out by matching the Foreign Key with the Primary Key of the referenced table; by looking at the data.

    Sometimes the Keys are named differently from one table to another that relate. For example the 'Document Number' fields in both of the following tables:

     Sales Invoice Header = [No_]

     Sales Invoice Line = [Document No_]

    Sometimes the Keys are named the same, for example the 'Item Number' fields in both of the following tables:

     Sales Invoice Line = [No_]

     Item = [No_]

    However, NAV/Business Central is fairly consistent. Once you see how several of the tables relate then you'll start to notice the convention that they used, which will help you figure out more table relations.

    Best Regards,

    Alex A

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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,742

#2
YUN ZHU Profile Picture

YUN ZHU 844 Super User 2025 Season 2

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 719 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans