Hello everybody,
I have two types of documents: Invoice and Payment
Payment contains a table section LineItems with an attribute of the type Invoice.
Payment
-LineItems
-Invoice
-...
Is it possible to join Payment to Invoice in a query of a dynamic list,
so that I can see all payment items regarding to the active row of invoices in a form table.
(directly in the list form)
e.g. the DataPath of the table would be: Items.ListOfInvoices.CurrentData.PaymentItems
where PaymentItems must be type of a ValueTable
I already know that i can create an event ListOnActivateRow of the Invoice form table,
do a query on the CurrentRow and fill a value table, but I want to know if there is an easier or more
efficient way to tackle this.