web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Union Query: I Have a ...

Finance | Project Operations, Human Resources, ...

Answered

Union Query: I Have a Grid That Displays a Union Query, But The TableId For All Records Are Coming The Same

(0) Share

Report

Report

Posted on by Momochi

1,036

Hello dears!

I have a union query which i'm using it in a grid. All records are coming but I have tableID included as a field in all the tables in the union query.

But the issue is, the table ID is coming the same for all the records. I have around 7 tables in the union query, but the tableID field in the grid is only displaying one value for all the records.

What I want to achieve is to display the records origin. I want to show that this record is coming from this table and the other record is coming from the other table and like that.

Is it possible?

Any advice is appreciated!

Thanks in advance!

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

ergun sahin 8,826 Moderator on at

Like (0)

Report

community.dynamics.com/.../how-to-add-tablename-id-to-union-view-in-dynamics-365-finance-and-operations

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Martin Dráb 664 Most Valuable Professional

#2

André Arnaud de Cal... 522 Super User 2025 Season 2

#3

Sohaib Cheema 303 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans