I have a procurement database where the Users can duplicate an old purchase request because the same item is purchased yearly. In my script for the user to duplicate, I have certain fields that are "Cleared" when the record is duplicated. I found that some of the fields that I requested "cleared" were not clearing. I realized that the User does not have access to those fields. How can I write the script so these fields will clear even though the user does not have access?

Thanks!

FileMaker Version: Dev 6

Platform: Windows 2000

Try using the Set Field script step with a null (double quotes) for those fields.

Set Field [fieldname, ""]

HTH, Mike

Mike,

Thanks, that makes sense. I was trying the "IsEmpty" function and that didn't work. I'll give it at try.

Thanks again!

Adele,

The IsEmpty function just checks to see if a field is empty, it does not clear the field.

HTH, Mike

Also, the good thing about the Set Field function is that you do not have to have the field on the current layout. You can be on one layout and use the Set Field function to modify a field on a different layout.

Mike