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.
Good morning, I have a question: Could be ” modify(“No.”)” instead “modify(Type)”?
LikeLike
We should take field which we are modifying using extension .If No field need to modify then we can use that field.
LikeLike
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
Yes .I will update that .Thank you
LikeLike
Thank to you, great post, I didn´t know we can do that in BC.
LikeLike
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