As I get drop-down for order number, can I get drop-down for external document no?
Note - As order no I am passing it as primary key in my table
This is my code:
trigger OnAction()
var varFilterPageBuilder: FilterPageBuilder;
Enquiries: Record Enquiries;
FilterExpr: text;
recEnquiries: Record Enquiries;
Past3Months: Date;
varDefaultView: Text;
varDateItem: Text[30];
cdu_FilterTokens: Codeunit "Filter Tokens";
begin
varFilterPageBuilder.AddTable('Enquiries', Database::Enquiries); // varFilterPageBuilder.AddField('Enquiries', Rec.No);
varFilterPageBuilder.AddField('Enquiries', Rec.Description); //External Document No
varFilterPageBuilder.AddField('Enquiries', Rec."Ship-to Post Code"); //Ship to Post Code
varFilterPageBuilder.AddField('Enquiries', Rec.Postcode); //Postcode
varFilterPageBuilder.AddField('Enquiries', Rec.No); //Order No varFilterPageBuilder.PageCaption := 'Enquiries Filter Page'; if varFilterPageBuilder.RunModal() then begin Enquiries.SetFilter(DateCreated, DateCreate);
if Enquiries.FindSet() then begin Enquiries.SetView(varFilterPageBuilder.GetView('Enquiries')); CurrPage.SetTableView(Enquiries); end; end; end;