3,027
Hi
In a report on request Page i have dropdown with options Import,Export,Others. On request Page there is another field. If Import is selected i want in second field only those Vendor's List should be displayed whose Gen Bus Posting Group is Import. If Export is selected in first variable then only those Vendor's List should be displayed whose Gen Bus Posting Group is Export.
Thanks
*This post is locked for comments
Hi
In CustNo i want to display list on the basis of selection .
Thanks
Hi
Sorry for that . CustNo is defined on Request Page. In this field List will be displayed. How it should be used. What should be its DataType.
CustType is actually Gen Bus Posting Group.
Thanks
Hi
I have written like this but it is giving error
The Customer has an Invalid DataType Record. The Valid DataTypes are Byte;Integer;Text;Code;
Customer - OnLookup(VAR Text : Text) : Boolean
Case CustomerType of
CustomerType::Import : CustNo.setrange("Customer Type", "Import");
CustpmerType::Export : CustNo.setrange("Customer Type", "Export");
end;
CustNo is of Record DataType.
Thanks
Hi @jsshivalik,
That's not a problem. As I suggest you option field is a global variavle. So all you need is to show related vendors only using OnLookup trigger of the second field depending on option field's value, . E.g.:
Vendor.reset;
Case Field1 of
Field1::Import: Vendor.setrange("Gen Bus Posting Group", GenBusPostingGroup1Code);
Field1::Export: Vendor.setrange("Gen Bus Posting Group", GenBusPostingGroup2Code);
Field1::Others: Vendor.setrange("Gen Bus Posting Group", GenBusPostingGroup3Code);
end;
if page.runmodal(0, Vendor) = action::lookupok then
Field2 := Vendor."No.";
If you have huge list of vendors than you should also use SETCURRENTKEY to change sorting to make table work faster.
Why do you need two fields? Why don't you just allow the selection of those Gen Bus Posting Groups?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (