Topic: File Save and Delete
I'm using a FILE field to save my files. I set the properties as follows:
COPY TO = Files and TYPE = LinkFile
This works fine and does what I want. And I can open up the file and edit it if I need to.
However, say I have a yearly license form that I want to save. I would like to replace the old license with the new copy.
I click on the FILE disk Icon and get a dropdown to OPEN FILE, OPEN FOLDER WITH FILE AND CLEAR.
When I choose CLEAR, it asks me Do you really want to delete the file from the database?
I answer yes and it clears the file name from the FILE field.
Then I hit save and I'm done.
Next I come back to the FILE field and ADD a new FILE to this same record.
It adds the file and puts the copy in the FILES folder as it should.
However the old file is still in the FILES folder.
It looks to me like if I did this with a number of Files that I would have extra files in the FILES folder that are orphans and don't belong to any particular record.
Any thoughts will be appreciated.