Update record overwrites existing file previously uploaded

I'm trying to follow the extremely out-of-date tutorial about making this pitiful upload file function work. I need an up-to-date answer really quick about this (with details on how to maneuver through all the work-arounds).

When I upload an image from my insert form - all is well. When I update that record, of course the file is overwritten in the database.

I have created the "hidden" field that has the database column name (photo) bound to it. Then, as the tutorial describes, I add a new "file field" and give it an ID (newphoto). The big problem here is that when moving on the Update Record Server Behavior work-around, the "newphoto" file field doesn't appear for me to select so I can change its property to "Server File Name".

HELP.

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

I managed to get it working. It is a bit confusing and still don't understand how it works. I am able to add the hidden field and create a new file field that has a different id. The confusion arises from the fact that that id doesn't bind or have a real column association in the data. I can tell you that part of the confusion comes from migrating from Adobe Developer Tools/InterAkt. I see other users who are in the same boat, and some of the concepts are different. That said, I don't see why, for instance, you can't specifiy a field as a file field in the Data Assist wizard. And the hidden/file field combo required to keep the updates from going awry could be built-in to the functionality without the numerous work arounds. Sure you guys are tired of being compared to Developer Tools, but honestly, I could fly through production with that framework. Webassist requires too many modules, wizards, work arounds, fixes, version updates, etc. to be really efficient.

For what it's worth. Thanks for your help.

in the File Upload server behavior, you bind the default file name to the hidden form element.

When the form is posted, File Upload Creates a variable called Server File Name

If a File is uploaded, the server File Name variable is set to the name of the file that was created on the server.

If no file is uploaded, the server file name variable is given the value of the Default File name setting. Where the default file name is bound to the hidden form element, it gets that value, which should be the file name already stored in the database.