Create a Page from 2 different tables

hiddentext

Is it possible to create a Page that based on 2 tables. I want to create a Page that combines both Purch Inv. Header and Purch Cr. Memo Header. Sort them by Posting Date.

ara3n

A page can have only one source table

You can add subpages (subforms) which will contain the secon table.

Marije_Brummel

Table 122 and 124 are almost identical.

Try using the SourceTableTemp property, make a page based on one of the table and populate it on the OnOpenPage trigger with a datefilter.

lvanvugt

As it's for RTC you are on SQL Server. Do you need the data only for viewing or also editing? Have you thought about using SQL view to accomplish this? See for details on that my blog post Using SQL views in NAV