Hi Guys ,
I would like to link two different table in one query report , how to do that ? I want all the production orders
to appear in the Ordered items to be delivered report
when I select a sales order . Kindly advise .
Thanks
Hi Guys ,
I would like to link two different table in one query report , how to do that ? I want all the production orders
to appear in the Ordered items to be delivered report
when I select a sales order . Kindly advise .
Thanks
If you look at the query for this report, it is already joining multiple tables, you can edit it to add something else as well, but you will need some SQL query JOIN writing knowledge.