Update the related record

[Mark Gimpaya]

what should i do to update an existing record in a portal/layout, if i also update the connected record from another table/layout

 

[comment]

8 hours ago, Mark Gimpaya said:

what should i do to update an existing record

Ideally, nothing - except possibly refresh the window.

In a well-designed relational database each fact is recorded in one place only. If updating one record requires updating another, then your database is not properly normalized and suffers from update anomaly.

 

Edited November 27, 2024 by comment

[bcooney]

All true, comment. But a logical data model may not be performant, and so cached data is helpful. To do so, we use transactions to ensure all necessary records are updated. 
 

as for OP, a portal in one window may not update in another window when a record is edited. As comment says, Refresh Window will trigger the client to request latest data from the server. This will happen on first draw of a window, and so navigating away and back will also fetch latest data. 

[comment]

3 minutes ago, bcooney said:

a logical data model may not be performant

That's why I said "ideally". Denormalization is a necessary evil, not a goal.