For example, we have a page will list all salesmen's information and with a photo each if submitted.
salesmen's information are from database. the images are saved in a image folder under web root.
the images are identified for each salesman either by salesman_id (auto increased number from database) or by a field called salesman_code (this field is only for this purpose).
If we can http upload the images, then we don't need to use an extra field "salesman_code", because we can program the images to be named after the salesman_id.
But if in some platforms, http upload is not allowed, ftp is the way to upload the images. User has to name the images and upload them, here comes the question:
1) should I still not use the "salesman_code" still ask the user to name the images after the "salesman_id"?
2) or I give the user a chance to assign salesman a "salesman_code" and use that code to name the images? this way, the user can assign salesman_code in a human easy to remeber way, then name the images accordingly.
3) but approach 2) will add a extra field called "salesman_code", and the user has to remeber the they cannot use one "salesman_code" for two people, if in the data input, they did that, the program will give them an error message. This extra step seems too much just for the purpose that the user can name the images in a easy to remember way rather than all by auto-increased numbers.
What is your opinion?
Thanks!
