How to extend TableRelation Property-Business Central

Last week somebody asked me on can we extend table relation property and my answer was yes we can achieve this by table extension.

Today we will see how we can do that

Firstly create enum extension and extend as follows . For this demo I used Type field from Sales line table.

enumextension 50145 PlaySaleDocType extends "Sales Line Type"
{
    value(8; Retail)
    {
        Caption = 'Retail';
    }
}

Secondly create a table extension and modify required table relation property.

tableextension 50146 PlaySalesTabRelExt extends "Sales Line"
{
    fields
    {
        modify("No.")
        {
            TableRelation = if (type = const(Retail)) Retail;
        }
    }

}

Hope this will help you.

Stay tuned for more update.

Author: Ammolh Saallvi

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

7 thoughts on “How to extend TableRelation Property-Business Central”

Pingback: How to extend TableRelation Property-Business Central - 365 Community

Good morning, I have a question: Could be ” modify(“No.”)” instead “modify(Type)”?

LikeLike

Ammolh Saallvi says:

May 13, 2020 at 12:29

We should take field which we are modifying using extension .If No field need to modify then we can use that field.

LikeLike

Reply
1. Jesus Almaraz Martín says:
  
  May 13, 2020 at 13:33
  
  Thanks for your answer, Ammolh.
  Yes, but I think you must extend “No.” field Tablerelation, not “Type” Tablerelation property. Type don´t have any Tablerelation:
  modify(“No.”)
  {
  TableRelation = if (type = const(Retail)) Retail;
  }
  }
  
  LikeLike
2. Ammolh Saallvi says:
  
  May 13, 2020 at 13:38
  
  Yes .I will update that .Thank you
  
  LikeLike
3. Jesus Almaraz Martín says:
  
  May 13, 2020 at 14:20
  
  Thank to you, great post, I didn´t know we can do that in BC.
  
  LikeLike
4. Ammolh Saallvi says:
  
  May 13, 2020 at 14:42
  
  Thanks for identifying that mistake. There are lot of things we can do n BC and as I finding that posting it on my blogs so it will help others.
  
  LikeLike

Share this:

Like this:

Related

Author: Ammolh Saallvi

7 thoughts on “How to extend TableRelation Property-Business Central”

Leave a Reply Cancel reply