Small and medium business | Business Central, N...

TableRelation conditionnal doesn't work

(0) Share

Report

Posted on by Magicrevette

215

Hello,

On table 263 - Intrastat Jnl. Line, I added a field in the TableExt :

field(8008001; LineType; Option)

{

Caption = 'Lige Type';

DataClassification = ToBeClassified;

OptionCaption = 'Item, Resource';

OptionMembers = Item, Resource;

}

And I've modified the field 20 - 'Item No.' :

modify("Item No.")

{

TableRelation =

if (LineType = const(Item)) Item

else

if (LineType = const(Resource)) Resource;

}

My prupose is : when a user on the page 311 Intrastat Journal adds a new entry, depending on if he choses Item or Resource in the field "Line type", the lookup they will see when they click on the field "Item No." will show items or resources.

The problem is : it doesn't work with this code. When I choose the option Resource, I only see items in the "Item No." Lookup on page 311.

What can I do to make it work please ?

All responses (4)

Answers (0)

Magicrevette 215 on at

Like (0)

Report

RE: TableRelation conditionnal doesn't work

I created a new field in the TableExt of Table 311 with the code of the standard field in it, plus my conditional TableRelation instead of the standard "TableRelation = Item". I also created a new field in the pageExt of Intrastat Journal to displays this new table field. And now it works !

Here is the code of my new tableExt field and pageExt field :

TableExt "Intrastat Jnl. Line" :

        field(1500; PWS_ItemNo; Code[20])

        {

            Caption = 'Item No.';

            TableRelation =

        if (LineType = const(Item)) Item

            else

            if (LineType = const(Resource)) Resource;

            trigger OnValidate()

            var

                Item: record Item;

            begin

                TestField("Source Type", 0);

                if "Item No." = '' then

                    Clear(Item)

                else

                    Item.Get("Item No.");

                Name := Item.Description;

                "Tariff No." := Item."Tariff No.";

                "Country/Region of Origin Code" := Item."Country/Region of Origin Code";

                GetItemDescription;

            end;

        }

pageExt  "Intrastat Journal" :

        addafter("Item No.")

        {

            field(PWS_ItemNo; PWS_ItemNo)

            {

                visible = true;

                ApplicationArea = All;

                Caption = 'PWS Item No.';

                ToolTip = 'PWS Item No.';

            }

        }

The former field (still doesn't work) :

The new field (it works) :

I think the problem comes from the property "TableRelation = Item" in the standard Table field "Item No.". In MS doc, it seems to say that the original TableRelation property cannot be changed. https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-tablerelation-property
Suggested answer

THE Italian on at

Like (0)

Report

RE: TableRelation conditionnal doesn't work

Looks good to me. What if you create the same Item No. like e.g. extItemNo. with the same code in the standard and extend this? Just to double check if this is related to standard field or custom table extension field extended a second time through your extension.

Last check. What is the build no. you are testing with?
Magicrevette 215 on at

Like (0)

Report

RE: TableRelation conditionnal doesn't work

Reflex from NAV 2018. I'v changed the field Option to Enum (I created an Enum).

The result is the same :/



enum 8007852 PWS_IntrastatJnlLine

{

Extensible = true;

  value(0; Item) { }

  value(1; Resource) { }

}

field(8008001; LineType; Enum PWS_IntrastatJnlLine)

        {

            Caption = 'Type Ligne';

            DataClassification = ToBeClassified;

        }

        modify("Item No.")

        {

            TableRelation =

            if (LineType = const(Item)) Item

            else

            if (LineType = const(Resource)) Resource;
}

Here, I only see Items in the Lookup, not Resources, even if the "Type ligne" shows Resource.
Suggested answer

THE Italian on at

Like (0)

Report

RE: TableRelation conditionnal doesn't work

Why you have added an Option and not an Enum?

Check this out

ammolhsaallvi.blog/.../

I would have used an Enum instead of the option. Give it a spin