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

Answered

Need to Filter lookup records in business central.

(0) Share

Report

Posted on by Inkey Solutions

2,122

Hi All,

I have one Enum type of Field in the vendor card page, and I have one field with lookup of Vendor table in the Fixed Asset card page, I want to filter lookup records in the Fixed Asset page based on selected value on the Vendor card page.

I tried to set table Relation property on the table field, but it is not working for me.

>>On fixed asset card page:

field(60151; "Gas Company"; Text[100])

{

DataClassification = ToBeClassified;

TableRelation = Vendor.Name where("Vendor Type" = filter(= 3));

}

Can anyone help in this?

Thank You.

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Nitin Verma

21,812 Moderator on at

Like (1)

Report

Copy link

Link copied!

Hi,

You can do like as per below, instead of Table Relation, as Table relation required only Primary key field, and you are putting here Name which is not a part of the Primary key field.

field(60151; "Gas Company"; Text[100])

{

DataClassification = ToBeClassified;

trigger OnLookup()

var

Vendor: Record Vendor;

begin

Vendor.SetRange("Vendor type",VendorType::YourOptionhere);

if page.RunModal(page::"Vendor List",Vendor)= Action::LookupOK then

"Gas Company" := Vendor.Name;

end;

}

Was this reply helpful? Yes No

Suggested answer

DAnny3211 11,423 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi

actually your code looks correct to me if your intention is to filter the vendor table for vendors that have vendor type=3

can you insert a screenshot of what you get?

what are the options of the enum of your Vendor Type field which I guess is Custom?

DAniele

Was this reply helpful? Yes No
Inkey Solutions 2,122 on at

Like (0)

Report
Copy link

Link copied!

Thank You Nitin Verma, this is work for me.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

Good news

Was this reply helpful? Yes No

Join the conversation

Community site session details

Need to Filter lookup records in business central.

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the June Top 10 Community Leaders

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

Featured topics

Product updates

Community site session details

Need to Filter lookup records in business central.

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the June Top 10 Community Leaders

Subscribe to this forum!

Select categories

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

Featured topics

Product updates