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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Updating a field based on user input from another form/table in x++

(0) ShareShare
ReportReport
Posted on by 70

Hi, 

I have a field named sequence number in the table InventQualityOrderLine. The table InventQualityOrderLine and InventQualityOrderLineResults has a relation with this sequence number, and when I try to update the sequence number, it will break the relation and not updating the InventQualityOrderLineResults with recently updated sequence number. 

Can anyone help me to update this as per my condition here ?


Regards,

C4u

I have the same question (0)
  • C4u Profile Picture
    70 on at

    Hi,

    I am just typing the sequence number in the quality order.

    1374.pastedimage1682508670727v1.png

    For example, I am changing the value of 1 to 10. This one represents the InventQualityOrderLine, I want this change to happen in the other table related (InventQualityOrderLineResults)

    Whenever I am updating the sequence number it creates a new test case. Let us consider, I have entered a test result for the test case with sequence number = 1. Now, I am changing the value of sequence number to 10 and the test result that I have mentioned disappeared now. But instead of results disappearing, I want them to be updated in the new test case as well

  • Mohit Rampal Profile Picture
    12,565 Moderator on at

    To update correct record in InventQualityOrderLineResults table, you need to get QualityOrderId, TestSequence, TestId and LineNum field values. How are you updating the TestSequence, please provide more details preferrably with form screenshots.

  • C4u Profile Picture
    70 on at

    Hi,

    I didn't write any codes in any method, can you help me to start with that. This relation is by standard one. I think I have to create a class extension for this.

    Regards,

    C4u

  • Mohit Rampal Profile Picture
    12,565 Moderator on at

    Hi, Please share your code. Are you updating Sequence field in both InventQualityOrderLine and InventQualityOrderLineResults tables.

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

News and Announcements

Season of Giving Solutions is Here!

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…

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

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 843 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

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

#3
Martin Dráb Profile Picture

Martin Dráb 325 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans