List Page with two source tables

DanielF · 2017-01-10

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 · 2017-01-10

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 · 2017-01-10

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 · 2017-01-10

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

EvR · 2017-01-11

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 · 2017-01-12

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.

List Page with two source tables

Answers

Categories