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

How to find all field references

(0) Share

Report

Posted on by yashi1985

I have created a function to auto update item cross reference code while scanning on sales order page.

I wanted to update this functionality in all the pages that uses cross reference barcode.

Is there any way in BC 17 to find all the references of field or table that are related to.

Thanks in advance

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

rkwadraat 10 on at

Like (1)

Report

make use of fieldref and the property relation

docs.microsoft.com/.../fieldref-relation-method

Was this reply helpful? Yes No
Lars Lohndorf-Larsen on at

Like (1)

Report

Good question, and also good reply to use FieldRef. Another way that will show you some detials is to look at the Field system-table:

page 50102 FieldList

{

    PageType = List;

    ApplicationArea = All;

    UsageCategory = Lists;

    SourceTable = Field;

    layout

    {

        area(Content)

        {

            repeater(GroupName)

            {

                field(TableNo; rec.TableNo) { ApplicationArea = All; }

                field(TableName; rec.TableName) { ApplicationArea = All; }

                field(FieldName; rec.FieldName) { ApplicationArea = All; }

                field(TableRelation; rec.RelationTableNo) { ApplicationArea = All; }

                field(Fieldrelation; rec.RelationFieldNo) { ApplicationArea = All; }

            }

        }

        area(Factboxes)

        {

        }

    }

    actions

    {

        area(Processing)

        {

            action(ActionName)

            {

                ApplicationArea = All;

                trigger OnAction();

                begin

                end;

            }

        }

    }

}

this will show you if a field is related to a table in properties. Except if the relation is conditional (for example "No." on a Sales Line. It also won't show any code relationships or where used. For that I don't think there are any tools at the moment, but I would be interested to hear if someone knows of any such tools.

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to find all field references

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

How to find all field references

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates