LaRetta Posted December 15, 2003 Share Posted December 15, 2003 Hi everyone, Duplicating a record can be dangerous as FM will also duplicate any Auto-Enter IDs which are based upon a calculation. And FM duplicates fields the User may not want to be duplicated , as it duplicates them all. Writing a 'Duplicate' script can be tedious and must be modified whenever new fields are added / removed to/from the database and the script must be hard-coded with all fields to duplicate via Set Field [ ]. If one has vs. >= 5.5, GetField[] could be used but even then, the options in this file can be beneficial. You can allow a User to select the fields to duplicate (via a checkbox) and the script adjusts accordingly . The checkbox will update automatically as fields are added/removed and the Developer is free - all that is needed is to drop a field on a secret layout! It is easy to set up and includes detailed instructions. This works whether working with All Records, a Found Set or whether a User has just signed on and is viewing a current record. Anyone can implement this process quite easily - even those new to FM. It is multi-user compatible and set to network, cross-compatible and works with any version of FM prior to 7. LaRetta Duplication.zip Link to comment Share on other sites More sharing options...
Recommended Posts