Forums
Lawson Add-Ins for Microsoft Office
Select multiple forms to query from Add-Ins?
Author
Messages
NH
Basic Member
Posts: 5
7/28/2022 6:14 PM
is it possible to select 2 forms i.e. BL20.1 and called form BL20.2 to query from Add-Ins?
John Henley
Senior Member
Posts: 3348
7/28/2022 6:22 PM
Hi NH, you can't do that directly, however a lot of forms share hidden fields between them, so it depends on which fields you want to include from each of the forms. Alternatively, you could query the file/tables and use the related tables *rather* than the form (e.g., OEINVOICE, OEINVCCOMM, OEINVCMISC, etc.)