I know other people are using separate tables to hold the memo fields. How do you get the "parent/calling form" to update correctly when creating a new memo?
I have a display form called "Order_form" based on a moderately complex set:
Order_header
- 1:M Order_items child
- 1:M - Other_charges grandchild.
- - 1:1 Memo table.
- - 1:1 Client table.
The problem occurs when a new order has been created and saved and a new Memo is added. (Both of which will be the last record in their respective tables, if that means anything.) A separate form is opened for entering the memo but when the memo is closed, the memo field on the "Order_form" won't update unless I either close the form and re-open it or do a Fetch_prev()/Fetch_next() which causes the form to "flash" and doesn't look very good to users. (Closing the form and re-opening it also works.)
I've tried multiple combinations of resynch, refresh, and repaint. I've also put these actions in various events and the Close button on the memo form. I've even tried activating various objects before refreshing, etc. - no luck finding anything that works consistently.
Please note, once a memo has been established, there is no problem updating changes.
Does anybody have a method that works consistently for NEW memos? If not, child memos apparently have the same 'refresh' issues as browses?
I have a display form called "Order_form" based on a moderately complex set:
Order_header
- 1:M Order_items child
- 1:M - Other_charges grandchild.
- - 1:1 Memo table.
- - 1:1 Client table.
The problem occurs when a new order has been created and saved and a new Memo is added. (Both of which will be the last record in their respective tables, if that means anything.) A separate form is opened for entering the memo but when the memo is closed, the memo field on the "Order_form" won't update unless I either close the form and re-open it or do a Fetch_prev()/Fetch_next() which causes the form to "flash" and doesn't look very good to users. (Closing the form and re-opening it also works.)
I've tried multiple combinations of resynch, refresh, and repaint. I've also put these actions in various events and the Close button on the memo form. I've even tried activating various objects before refreshing, etc. - no luck finding anything that works consistently.
Please note, once a memo has been established, there is no problem updating changes.
Does anybody have a method that works consistently for NEW memos? If not, child memos apparently have the same 'refresh' issues as browses?
Comment