Plaza 365
Plaza 365

No results found for your search

RegisterLog in

3

Dynamics 365 Business Central: How to export all TableRelation information (For example, find all tables and fields related to Customer Table)

Visit article

#export

#fields

#table

#tables

Dynamics 365 Business Central

Category

Feb 22, 2025

Published date

Text

Article Type

AI Summary

  • The TableRelation property in Dynamics 365 Business Central allows for establishing lookups into other tables to link information.
  • To export all TableRelation information, system table 2000000141 "Table Relations Metadata" can be used, but it cannot be opened directly from the client URL.
  • Creating a simple list page in Business Central to filter Related Table ID can help find all tables and fields related to a specific table, such as the Customer Table.
  • The "No." field in table 37 "Sales Line" can be referenced in table 2000000141 "Table Relations Metadata" for additional details.
  • Information on TestTableRelation Property and ValidateTableRelation Property can also be found in the same table.
  • Table 2000000041 "Field" provides similar information but may not display if multiple conditions are set.
  • Articles related to extending TableRelation Property through table extensions and customizing Drop-Down lists in Dynamics 365 Business Central are available for further reference.
  • Business Central 2023 wave 2 introduces the capability to add a new FieldGroup to existing tables, enhancing data organization and visualization on the UI.

Registered users can view the full text for FREE!

Sign In Now!