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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Grid with fields from ...
Finance | Project Operations, Human Resources, ...
Unanswered

Grid with fields from 2 datasources does't load the linked value after saving new record

(0) ShareShare
ReportReport
Posted on by Carlo T 30

Hello,

I have a form with 2 datasources.

- New_Table

-RouteTable

the new table has relation to RouteTable on RouteId with relation 0 to 1 to RouteTable.

On the form I have a grid with datasource = New Table.

The grid has fields from NewTAble and one field from RouteTable. RouteTable.Name.

When I open the form I can see the name for all existing records. The join on the datasource RouteTable is set to InnerJoin.

May problem is that when I add a new record the Name stays empty even when I move to the record below in the grid. 

I've tried overriding the write method and forcing a reread() and refresh() of both datasources but not successs.

I have the same question (0)
  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,423 on at

    Hi Carlo,

    Based on which fields have you set the relation between New_Table and RouteTable?

  • Carlo T Profile Picture
    Carlo T 30 on at

    Thank you Gunjan,

    I specified in my original message that the NewTable relates to RouteTable with the field RouteId

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,423 on at

    Sorry Carlo. I missed that part.

    On creating a new record in New_Table, are you creating a new Route as well? Or are you choosing an existing RouteId?

  • Carlo T Profile Picture
    Carlo T 30 on at

    No. New records are only in New Table. the join to RouteTable is to display the Name of the Route associated with RouteId.

    I can solve the problem with a Display method on my NewTable but with Display method I can't sort or search on the grid.

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,423 on at

    Hi Carlo,

    Have you set the AllowCreate, AllowDelete and AllowEdit properties to No in RouteTable data source?

  • Carlo T Profile Picture
    Carlo T 30 on at

    Yes.

    My problem is not the creation. My problem is that when I create a new record  or modify a record in NewTable the field 'Name' that I pull from the joined RouteTable doesn't refresh until I reopen the form.

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,423 on at

    These properties should be set to No so that the user is unable to create a record in RouteTable. You can then change the Link type on data source RouteTable to Active and check if the Name field is displayed correctly.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
Martin Dráb Profile Picture

Martin Dráb 611 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans