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".