Duplication - On the Fly! - Community Videos, Tips, & Techniques, Articles.

December 15, 200322 yr

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