How to maintain current status after a change and save (commit)?
I'm fairly new to Filemaker/scripting, so excuse me if I ask the obvious. I've got a problem wtih a script/layout. My script presents an overview a club members, conditional to whether tthey have paid thier club dues in a certain period. Simple, presenting the contents a table (call it table1). It works fine, no problem. But in another table in the database (table2) I store totals for the given period. My layout is designed to also display the totals from this table (table2) and that works fine too. The problem is that when I save the totals to table2 (using a commit step), the saved record ceases to be current and table2 reverts to the first record. This causes my totals to disappear on the layout. I need to be able to save the record to table2 and also for the record to remain current so the appropriate field values are presented on the layout. Is this possible?