web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Facing problem to crea...
Small and medium business | Business Central, N...
Suggested Answer

Facing problem to create a list page help of two different table.

(0) ShareShare
ReportReport
Posted on by navision begginers 387

Dear Experts,

i am facing problem to create a list page.

I have two different table. first table is 'Requisition Line' table no. 246 and other table is a customized table no. is 50048. All deleted records from table 246 is present in customized table.

My concern is, I want to display both table data in a new list page.

How can I do that. Please help me to resolve it.

I have the same question (0)
  • Suggested answer
    Gearoid Profile Picture
    Gearoid Microsoft Employee on at

    Hi,

    One possibility would be to create a SQL Server View in the NAV database which combines the information from table 246 and table 50048 using a TSQL UNION statement. After that you could create a new NAV table in the NAV development environment with LinkedObject property = Yes and named to match the SQL view. You could then create your List page using the new NAV table which is linked to the SQL view.

    If you use this approach the NAV table name must match the SQL view name exactly. The SQL view column names must also match the relevant NAV table's field names. The SQL view name should also include the relevant NAV Company name.

  • navision begginers Profile Picture
    navision begginers 387 on at

    thank you so much for your fast reply. I have done the same which you have saying.

    but when I am running the new page always getting the below error:

    Microsoft Dynamics NAV

    ---------------------------

    The following SQL error was unexpected:

    Invalid object name 'UAT2021.dbo.MKU Private Limited$___Indent_Vs_Archieve_Indent'.

    Statement(s) could not be prepared.

    ---------------------------

    OK

    ---------------------------

  • Suggested answer
    Gearoid Profile Picture
    Gearoid Microsoft Employee on at

    Hi,

    Sounds like it needs some investigation. Hopefully the following hints can help: 

    Try running the relevant table directly in the NAV Development environment to see if you get any more helpful information. 
    Try selecting directly from the View in SQL Server Management Studio.
    See what happens if you run the following TSQL command in SQL Server Management Studio: SELECT * from UAT2021.dbo.[MKU Private Limited$___Indent_Vs_Archieve_Indent]

    If the cause of the problem is still not clear after trying the above you could run a SQL Profiler trace to capture more details about the SQL error. 

    If the problem persists I would recommend opening a support ticket with Microsoft via your Solution Provider or Dynamics NAV Partner. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,958 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,101 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 959 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans