June 2, 200124 yr Is there a way to track edits & the user doing the editing keeping memory use to a minimum? I have layouts with multiple fields for all kinds of demographic data for each client. Should a user edit any of these fields, I would like to keep track of these changes. I've thought about a comand to duplicate the record just before the edit and making the new copy the active copy but this saves editted and uneditted info. Also considered: making each field a button that enters that field zas well as copying its data to a global field that corresponds to the selected field, and when the "editing done" button is clicked, copies the the values in the global fields into a file created for tracking edits. I understand that Access has a script if record "dirty" (edited) alows the new and old data to be saved. Any suchthing in FMP5?
June 2, 200124 yr Check out this file from www.databasepros.com: http://www.best.com/~jmo/Field_Mod.sit It shows how to do what you want to some complex calculations and lookups, but it works well, as I've used the technique in one of my own solutions. Chuck
Create an account or sign in to comment