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 / Microsoft Dynamics AX (Archived) / how to assign a field ...
Microsoft Dynamics AX (Archived)

how to assign a field as RecID through creating a new relation in a table while there is another relation linked with field through that table.

(0) ShareShare
ReportReport
Posted on by Codehunter 10,280

i need to handle that field as RecID to be assigned with another relation through certain table PurchReqBusinessJustificationCodes but i got conflict error while adding new relation...Plz anybody help me ASAP.

*This post is locked for comments

I have the same question (0)
  • Bilal Issa Profile Picture
    Bilal Issa 4,370 on at

    Hi ,

    are you trying to populate the field through code , or you have join data sources?

    Regards,

    Bilal

  • Codehunter Profile Picture
    Codehunter 10,280 on at

    no i only need to modify certain relation in the same table to refer to RecID of another table as it is shown below:

    Relation in a table needs to be changed

    PurchReqTable.BusinessJusticiation==BusinessJusticiationCodes.RecID

    i need to change that BusinessJusticiationCodes and call another table

    You get what i mean..

  • Bilal Issa Profile Picture
    Bilal Issa 4,370 on at

    if you have two relation pointing to the same table then you need to fill the related table role and role id properties, and if you are modify existing one, then I suggest to delete it and create new one.  

  • Codehunter Profile Picture
    Codehunter 10,280 on at

    I cannot delete the existing one because it is created by the system itself

  • Codehunter Profile Picture
    Codehunter 10,280 on at

    Plz help me

  • Codehunter Profile Picture
    Codehunter 10,280 on at

    I can't create another relation linked with that field as that field is linked with existing relation in the table so my main target is to let that field point to another relation

  • Bilal Issa Profile Picture
    Bilal Issa 4,370 on at

    since it a standard field you can't change it because it exist in Sys layer, but I suggest to add a custom field of type enum of Type YesNo and make it invisible  and add that as fix field value to the existing relation of value 'Yes', the create new relation to the new table with also fixed field value 'No', ad fill role Id property .

  • Codehunter Profile Picture
    Codehunter 10,280 on at

    I need to assign that new field to the existing field

  • Codehunter Profile Picture
    Codehunter 10,280 on at

    How can I do that??

  • Codehunter Profile Picture
    Codehunter 10,280 on at

    Plz I need it urgently

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 > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans