News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Form grid loss focus a...

Finance | Project Operations, Human Resources, ...

Suggested answer

Form grid loss focus after add a view on OUTER JOIN

(0) Share

Report

Report

Posted on by Diego Mancassola

237

Hi community, strange problem.

On the SalesTable form i have added a datasoure based on a View.

This view, has some data at InventTransId level, and i have linked to SalesLine in OUTERJOIN mode, join is made on SalesId and InventTransId

After adding datasource the sales line's grid loss focus and moves to the first line when i peform an operation on sales line.

If i remove the new DS the focus remain on selected line.

I don't know, there are some limitations using VIEW on a form?

Thanks a lot

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

GirishS 27,825 Moderator on at

Like (0)

Report

RE: Form grid loss focus after add a view on OUTER JOIN

Hi Diego,

Its hard to find the issue. But you can solve this issue by calling positionToRecord method on datasource executeQuery method.

Thanks,

Girish S.

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Quick Links

Leaderboard

#1

André Arnaud de Cal... 294,060 Super User 2025 Season 1

#2

Martin Dráb 232,858 Most Valuable Professional

#3

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans