2,963
Hi All
Is it possible to create a dependent drop-down list (Enum or OPTION) so, for example, you have a group and sub-group where sub-group values are filtered based on the group. For example, select a country from country drop down field and you see states within that country selected on the state field available values
Thanks
Yes it is possible.
You can look at how it is done f.ex with the post code on the customer and vendor table.
There the lookup of post codes are dependent on the country you have selected.
You also have the same method when it comes to city (field 7 in the customer table.
Share
Report
All responses (
Answers (
field(91; "Post Code"; Code[20])
{
Caption = 'Post Code';
TableRelation = IF ("Country/Region Code" = CONST('')) "Post Code"
ELSE
IF ("Country/Region Code" = FILTER(<> '')) "Post Code" WHERE("Country/Region Code" = FIELD("Country/Region Code"));
//This property is currently not supported
//TestTableRelation = false;
ValidateTableRelation = false;
trigger OnLookup()
begin
OnBeforeLookupPostCode(Rec, PostCode);
PostCode.LookupPostCode(City, "Post Code", County, "Country/Region Code");
OnAfterLookupPostCode(Rec, PostCode);
end;
trigger OnValidate()
begin
OnBeforeValidatePostCode(Rec, PostCode);
PostCode.ValidatePostCode(City, "Post Code", County, "Country/Region Code", (CurrFieldNo <> 0) and GuiAllowed);
OnAfterValidatePostCode(Rec, xRec);
end;
}
Really powerful function.
#1
Sohail Ahmed
2,655
#2
Mansi Soni
1,574
#3
YUN ZHU
1,453
Super User 2025 Season 1
