How to Get a List of Tables Related to the Item Table

(3) Share

Report

Posted on by Shraddha Jadav

Hi,

I’m working on a project where I’ve added a new field, Part No., to the Item table, and it’s set as a unique key. In my project, items are identified by Part No. instead of the traditional Item No..

To ensure that Part No. flows seamlessly wherever Item No. is currently used in the system, I need to identify all the tables that are related to the Item table or contain the Item No. field. This will help me update those tables to use Part No. appropriately.

Could you please guide me on how to get a comprehensive list of tables related to the Item table or any tools/queries that can help with this analysis?

Thank you!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Ramiz 597 on at

Like (1)

Report

Hi,

Hope this helps.

https://bcentral.dev/nav/2018/w1/table/item

https://community.dynamics.com/blogs/post/?postid=6dbffe5d-a8fb-425e-bb11-191e9f8b4af4

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (1)

Report

Hi, try the following system table

?table=2000000041

More details: https://yzhums.com/1055/

Thanks

ZHU

Was this reply helpful? Yes No
Verified answer

Alexander Drogin 262 on at

Like (2)

Report

In AL, you can get all the references from the system table "Table Relation Metadata. Filter the table on the "Related Table ID" field:

var TableRelMetadata: Record "Table Relations Metadata";

TableRelMetadata.SetRange("Related Table ID", Database::Item);

TableRelMetadata.FindSet();

This table contains all table relation references, but not flowfield definition though, if there are any flowfields that refer to the Item table.

Actually, Visual Studio Code is the best tool for this task if you don't mind some hassle of building the Business Central app from the source code. It is open source, but you still need to get access to the repository and set up the build. But once you've built it, VS Code tools can give you all insights. "Go to References" counts all kinds of table references.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,275 Super User 2025 Season 2 on at

Like (2)

Report

JFI: https://bcentral.dev/

Was this reply helpful? Yes No