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

225

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,832 Super User 2024 Season 1 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

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans