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
Hi,
I am just typing the sequence number in the quality order.
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
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.
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
Hi, Please share your code. Are you updating Sequence field in both InventQualityOrderLine and InventQualityOrderLineResults tables.
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,836
Most Valuable Professional
nmaenpaa
101,156