Updating a column automatically, when another column is updated in a table

(0) Share

Report

Posted on by Community Member

Hello ,

as mentioned in the Subject, how can I update a value automatically when the the other is updated?

I want to update the field "InventLocationId" in the sales line . the "InventLocationId" in the Intercompany PO will be automatically updated .

I'm assuming that I can accomplish this by putting my code in "Modify" method in "InventLocationId" field in the "InventDim" table in both "purchTable" and "SalesTable" Forms ?

thank you.

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

To do this in a more elegant way, you could place your code in the insert() or update() methods of the table, and check if (this.orig().InventLocationId != this.InventLocationId), then change it in the other table. This will ensure that you only modify the connected values if the user is saving the changes.

Was this reply helpful? Yes No