Create a Page from 2 different tables

hiddentext · 2010-01-07

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 · 2010-01-07

A page can have only one source table

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

Marije_Brummel · 2010-01-07

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 · 2010-01-07

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

Create a Page from 2 different tables

Comments

Categories