Clearing Fields in Duplication of Records

[littleitaly5588]

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

[Mike D.]

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

Set Field [fieldname, ""]

HTH, Mike

[littleitaly5588]

Mike,

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

Thanks again!

[Mike D.]

Adele,

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

HTH, Mike

[Mike D.]

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