All about Microsoft Dynamics NAV and Business Central
How to find Table Relation in Business Central.
With the release of business central new property is introduced to find the table relation of given field. This property is called as’ Relation’ which returns integer value
Lets see how we can find that .
To make it created one page extension and added one action button to display the value of table of given field.
If you see the highlighted area where in I have used relation property to find table id of CITY field of customer table.
I'm a Dynamics NAV/Navision developer and helps partners and end-users with their NAV implementations. I do everything from third-party management advisory, training to new NAV teams, project management, training, setup and development.
Do you want to hire me to help getting your project a success? Then contact me via dropping one email from linkedin
Expertise in end-to-end development of software products from requirement analysis to System Study, Documentation and Testing. Demonstrated abilities in analyzing information system needs, evaluating end-user requirements, custom designing solutions, troubleshooting for complex information systems management. Deft at carrying out risk analysis, impact analysis, project reviews and documentation. Strong Problem solving & Technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction as well as low operational costs.
Certifications:-
Microsoft Certified Technology Specialist -Dynamics
Microsoft Sure Step Certified Professional
Moderator at DUG Forum
Specialties: • ERP Implementation
• Client/Server Programming
• Coding, Testing, troubleshooting and documentation.
• Database Tuning and SQL
• Database Performance
• Debugging large programs
• Project Management and Resource Management.
View all posts by Ammolh Saallvi
5 thoughts on “How to find Table Relation in Business Central.”
The method is not new: https://docs.microsoft.com/en-us/dynamics-nav/relation-function–record-
LikeLike
But I think it is new for the developer of BC as it was not part of C/AL isn’t it
LikeLike
Sorry, the link was broken. The double – – (only directly after “/relation-function”) has been converted to a single long -.
LikeLike