How do I update a column in another block?
I have a form that has dorm room assignment information in one block--multiple rows, and a related block with check in/out information, one row for each assignment row. If the user updates the assignment information, setting a room assignment to inactive and inserting a new row for the new room assingment, then I need to update the check in/out info associated with the old room to set a 'move out by' date. I'm having difficulty doing this because the focus is usually but not always, on the new room assignment, rather then the old, when the form is committed--which makes it hard to get the correct row updated in the check in/out block. If I do a sql to update the underlying table instead, then the change doesn't necessarily show in the form. So what is the proper way to update data in an associated block when data in the master block changes?