I am trying to make a report which shows the purchase orders of currently active projects.
Can I filter the =NL function which returns purchaseheader rows on a field in a different project tabel?
The projectnumber can be found in the purchaseheader.
I am trying to make a report which shows the purchase orders of currently active projects.
Can I filter the =NL function which returns purchaseheader rows on a field in a different project tabel?
The projectnumber can be found in the purchaseheader.
Hi Menno
You have two options: use the NL Filter (on the Options tab) to create a list of active project code, or the NL Link function on the order header
Thank you Malcom, works great with the LINK function.