filter item from dropdown list

Dynamics 365 Business Central/NAV Developers Forum
1

Hi,

I have a dropdownl list that items returns from the database. There are five items. But I want to have one time not showing in the list.

I have this:

FrmLocationMethod.LOOKUPMODE(TRUE);
IF FrmLocationMethod.RUNMODAL = ACTION::LookupOK THEN BEGIN
FrmLocationMethod.GETRECORD(LocLocationtMethod);
RecSalesHeader.“Location Code” := LocLocationtMethod.Code;
END;

CurrForm.UPDATE;

Thank you.

2

you could work with a temp table of same rec type. create that at runtime, fill only the items you want, use the temp table as base for the dropdown.

3

Thank you for your answare. I solved :slight_smile:

4

Hi Niels,
If Jons suggestion didn’t help you, would you mind sharing the solution that solved your problem. Just so that it might help the next member with the same problem. :slight_smile: