Hello Satya,
I am not sure I have hit your exact requirements but I made a small sample page below with two fields, each one has a lookup that opens a filtered Item list, and then you can select from that list. If this was not what you were looking for, just let me know and I will try to think of something else.
beware that in the web client there is not a big distinction between lookup and drilldown, and in case you make a field uneditable, then the drilldown disappears. For example if you do not want users to type in a value manually but still be able to choose from a list. So my advice will be for you to just use OnLookup triggers, but this is only a suggestion for consideration, since of course I dont know your whole set of specifications.
page is below - I hope it helps:
page 50101 FilterPage
{
PageType = Card;
ApplicationArea = All;
UsageCategory = Administration;
layout
{
area(Content)
{
group(GroupName)
{
field(Drilldown; Value1)
{
Caption = 'Drilldown';
ApplicationArea = All;
trigger OnDrillDown()
begin
item.reset;
Item.calcfields("Assembly BOM");
Item.setrange("Assembly BOM", true);
if page.RunModal(0, Item) = action::LookupOK then
Value1 := Item.Description
else
Value1 := '';
end;
}
field(Lookup; Value2)
{
Caption = 'Lookup';
ApplicationArea = all;
trigger OnLookup(var Text: Text): Boolean
begin
item.reset;
Item.setfilter("No.", '1896-S|1906-S|1928-S');
if page.RunModal(0, Item) = action::LookupOK then
Value1 := Item."No."
else
Value1 := '';
end;
}
}
}
}
actions
{
area(Processing)
{
action(ActionName)
{
ApplicationArea = All;
trigger OnAction()
begin
end;
}
}
}
var
Item: Record Item;
Value1, Value2 : Text;
}