ParvusAnimus

Thanks for all your help! I got the script working as follow: Set Variable [ $parentRecordID; Value:transaction::account_id ] Delete Record/Request Go to Layout [ “account” (account) ] Enter Find Mode [] Set Field [ account::id; $parentRecordID ] Perform Find []

Hello, I'm very new to FM although I do have extensive SQL skills(maybe that's why I'm not really getting anywhere with FM). Anyway, I have a database with a Parent-Child(one-to-many) relationship between two tables, one for Bank Accounts, and one for Transactions. On the transaction form, I have a button to execute a script. What that script does is to: 1. delete current record 2. go to related record(in this case, the bank account the record -- the record that has just been deleted -- belonged to) The script works fine when there is more one transaction in a bank account(I think it's because even the current record has just been deleted, there are still other transaction left for the relation to work). However, when there is only one transaction left, after deleting the current record, there is no more record left to make the relation, and I can't get back to the related bank account anymore. So, is there anyway(using variable or not, ...) to "remember" what the related record was before, delete the current record, then go to the related record? Thanks