June 21, 200718 yr Newbies When you "Duplicate" an existing record, is there anyway to have certain fields made blank automatically on duplication?
June 21, 200718 yr Firstly - I'm not an expert by any means, but I've had some excellent help on this forum. Since yours is unanswered at this point I'll do my best until you get some advice from the pros. I guess that you want to duplicate a record so that you can keep some of the information that was in the original record, then have the user adjust the new record.... I do this by using a script... DuplicateRecord Clear(FieldYou WantTo Clear) Clear(FieldYou WantTo Clear) etc.
June 21, 200718 yr You could also use the following Duplicate record Set Field [yourfield; ""] Set Field [yourfield2; ""] Set Field [yourfield3; ""] The clear step that cg used can be used to clear all the contents of a field but can also be used to clear some of the contents of a field (depending on the cursor position). The set field command always sets all of the field to your choice (in this case ""= null or nothing) and so is possibly preferable so as to avoid any confusion HTH Phil
June 21, 200718 yr Or Make autoenters in the fields that needs blanking... See attachment! See the differnce between the scripted and the key combo... --sd dupe.zip
Create an account or sign in to comment