1,745
i want to lookup on multiple table in a request page just like bank payment voucher where one can select account type like customer ,vendor ,and based on the value of account type one can look up in the respective table .like for customer ,one can lookup in the customer table.for account type vendor one can lookup in vendor table .
*This post is locked for comments
I have written the below code
CheckLeaves.RESET;
CheckLeaves."Payee Name":=PayeeName;
IF PAGE.RUNMODAL(50100,CheckLeaves) = ACTION::LookupOK THEN BEGIN
Text := FORMAT(CheckLeaves."Payee Name");
EXIT(TRUE);
END;
in the onlookup trigger but i want to implement find as type in this .
Hi Javed,
You may use two fields on the request page, one for the type, i.e, Vendor, Customer etc. and another one for capturing the Code (vendor code, customer code) etc.
Then, you need to write code in the AssistEdit of the Code field to have the lookup based on the selected value in the type field.
Please add some filter on your data items so it comes by default every time on request page.
You can add it in report by going into property of data item --> ReqFilterFields
Note: Requires filter table must be in report dataitem
Saurabh
requirement is clear.
what did you try and what is not working?
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 (