web

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

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Populate RecId of one ...

Microsoft Dynamics AX (Archived)

Populate RecId of one table from RecId of another table

(0) Share

Report

Report

Posted on by Rohin

4,624

Hi,

I have one New Table . I have to store recid of another table in Recid field of New table . Like this :

newTable.RecID = anotherTable.ReciD;

is it right to do ?

please suggest

Thanks

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (6)

Answers Img

Answers (0)

Suggested answer

PA-22040759-0 6,194 on at

Like (0)

Report

You should not overwrite the RecId field of your "newTable". To set up a reference to a RecId from another table, you'll need a new field for the reference RecId. The datatype for this should be RefRecId or an extension of that.

One example from the standard application could be the ReasonRefRecId field of the CustTrans table.

Was this reply helpful? Yes No
Rohin 4,624 on at

Like (0)

Report

Okay Thanks, I have create one Field of Int64 ( EDT reference to RefRecId) , but when i updated This field by recid of another field like this :

NewTable.RefrecId = anothertable.recId;

Then New Table has zero value for RefRecId . i don't understand why this shows 0

Looking for your suggestion please.

Thanks

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

Hey Visvash Walia,

Can you share your code or other details ? When do you do this update ?

Was this reply helpful? Yes No
Rohin 4,624 on at

Like (0)

Report

Thanks ievgen & palle ,

Now its working fine. Recid is successfully updated in NewTable using above code mentioned.

Thanks

Was this reply helpful? Yes No
Rohin 4,624 on at

Like (0)

Report

Hello ievgen,

Sorry , Its not working well. Sometimes there is RecId in newTable and sometimes its value zero . Please suggest

i used below code :

Was this reply helpful? Yes No
Rohin 4,624 on at

Like (0)

Report

Anybody has suggestion on this ?

Thanks

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