web

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

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Edit table from form

Microsoft Dynamics AX (Archived)

Edit table from form

(0) Share

Report

Report

Posted on by ismaelivan

578

I have a form with a view and a table as a data source, how can I edit the values in the table?

DataSource

-> Table

-> View

GridView

Table_Field1, Table_Field2, View_Field1, View_Field2 ....

How i can edit Table_Field1 and Table_Field2???

Actually my gridview has Table datasource, and it allows me to edit, but I do not know how to relate 'View.RecIdCustTrans' -> 'Table.ReferenceRecId'

Thank Very much

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report

Hi,

Instead of adding view as the datasource, you can include the tables from the view query as datasources to the form and join your table(as datasource) using properties joinsource and LinkType.

Refer following links:

(Form Data Source Properties [AX 2012])

msdn.microsoft.com/.../aa676742.aspx

(Form data source link types - Active, Delay, Passive, Inner join, Outer join, Exist join, Not exist join)

community.dynamics.com/.../form-data-source-link-types-active-delay-passive-inner-join-outer-join-exist-join-not-exist-join

Was this reply helpful? Yes No
ismaelivan 578 on at

Like (0)

Report

That try, but I do not know how to specify the fields to relate, in this case 'CustTrans.RecId' -> 'MyTable.ReferenceRecId'

Was this reply helpful? Yes No
Verified answer

Chaitanya Golla 17,225 on at

Like (0)

Report

Hi,

Define the relation between the two tables CustTrans and MyTable at the table level(Path: \Data Dictionary\Tables\SampleTable\Relations) & also the required delete action(Path: \Data Dictionary\Tables\CustTrans\DeleteActions).

Refer following link:

(How to: Add a Relation to a Table [AX 2012])

msdn.microsoft.com/.../aa556809.aspx

Was this reply helpful? Yes No
ismaelivan 578 on at

Like (0)

Report

I did what you mentioned in the previous post, and also commented on the write() event of the view. It worked. thank you very much,

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Martin Dráb 4 Most Valuable Professional

#1

#3

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans