Uploading file and saving filename to database
Like most of the questions I post here, this is another where I'm in the process of figuring it all out but just want to make sure I'm not missing anything. And even if it doesn't seem like it, I do do my home work and read the documentation and search the forum.
I applied a file field to an update page, replacing a text field that contained the image name. I kept the field name the smae and did not change the update record behavior. This actually worked as I was able to upload and replace the file. But when I went to update another item on the form it deleted my image name from the database. So after my research I made the following changes and so far so good. Please confirm that I have everything correctly cofigured.
1. In the upload Files behavor, the File field is bound to the File Field form element
2. The default file is bound to the column from the recordset that contains the filename
3. In the Data Assist update behavior, the database column is bound to the "Server File Name". found in the section called "Upload Files (myFileFieldName). I imagine the other options in this section are used for whatever they represent and what may be written to other database fields if needed, but for now I"m keeping it simple.