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

(2) 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

All responses (2)

Answers (0)

Suggested answer

YUN ZHU 74,280 Super User 2024 Season 2 on at

Like (0)

Report

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

Hi, try the following system table

?table=2000000041

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

Thanks

ZHU
Suggested answer

Ramiz 402 on at

Like (1)

Report

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

Hi,

Hope this helps.

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

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