passing the data from one table to another table

(0) Share

Report

Posted on by Community Member

hi ,,

when i create the new record it gets updated in main table.. when the new record is created in maintable it also need to be created in related table ..can any one help me with examples

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report
Copy link

Link copied!

check this links

stackoverflow.com/.../how-to-update-data-in-one-table-from-corresponding-data-in-another-table-in-sql

www.youtube.com/watch

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

hello mahmoud,

actually records need to be reflected in the new record ...in ax

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I feel this can be achieved through one of the following ways.

i. One way is to make use of table inheritance (as suggested by Crispin).

Refer below links:

(Table Inheritance Overview [AX 2012])
https://msdn.microsoft.com/en-us/library/gg881053.aspx

(Walkthrough: Creating Base and Derived Tables [AX 2012])

https://msdn.microsoft.com/en-us/library/gg844024.aspx

(When to Use Table Inheritance [AX 2012])

https://msdn.microsoft.com/en-us/library/gg843731.aspx

ii. Another way is to create a posteventhandler to the insert method of tableA and fill in the details of tableB from tableA.

Typically your code looks like below.
Path: \Data Dictionary\Tables\TableA\Methods\insert\PostEventHandler

public static void postinsertEventHandler(XppPrePostArgs _args)
{
TableA tableA = _args.getThis();
TableB tableB;

tableB = TableB::find();

if (tableB.recid == 0)
{
tableB.Field1 = tableA.Field1;
tableB.Field1 = tableA.Field1;
}
}

Refer links:
(How to use Event Handler in Microsoft Dynamics AX 2012:)
https://chaituax.wordpress.com/2014/04/09/how-to-use-event-handler-in-microsoft-dynamics-ax-2012/

(Event Handling in Microsoft Dynamics AX 2012)

https://community.dynamics.com/gp/b/erpsoftwareblog/archive/2012/06/25/event-handling-in-microsoft-dynamics-ax-2012

iii. Same code can be written in the insert method of TableA after super()

Was this reply helpful? Yes No