List Page with two source tables

DanielF

Hi everyone,

is there a possibility to create a List Page with two source tables?
For example a List Page with Purchase Invoice Lines AND Purchase Receipt Lines.
In SQL it would be a view with SQL command UNION on two tables.

I would be very pleased if I could get help or further information on this topic.

Thanks in advance.

Daniel

mohana_cse06

no, you have to use one of them as temporary source table and fill the details with other table also while opening and show them on page.

RockWithNAV

You can create a SQL view based on these tables and then you can create a NAV Table on the base of this SQL View. Check this

https://rockwithnav.wordpress.com/2016/11/29/sql-view-nav/

DanielF

Thanks guys! For future requirements I will try implement a SQL View.

EvR

I would always advise against using SQL views.
It's not exactly future/cloud proof and it adds unnecessary complexity to your installation and maintainability.

awarn

Agree - temporary tables is the way to go here, you could re-use one of the tables and copy the other recordset in or create a new table for the combination of data.

One advantage to a temporary table is that if you need this report elsewhere (i.e. in a report), you can re-use the code that scans the tables & creates the data for the page & report.