Insert and Uploading an Image
I am using data assist to create an admin area. However, when combining "INSERT" with an Image Upload I have an issue.
1: The image name is related to the "auto increment" ID for the record in the database. For instance - if the record ID = 191, the name of the image will be "191_img.jpg".
2: I understand that on INSERT, WA creates a session variable for the new session ID.
3: On the Insert page, I have created the uploads using the upload wizard, and set the name as "<session var>_img".
The problem is, it is not grabbing the latest insert record ID, it is using the ID from the previous record. (EG: The new record might be 192, but it is uploading the image as 191).
When I look at the code, it seems to be putting the upload prior to the insert, which would explain this.
Should I be using a different TRIGGER (currently it is set for when the INSERT is pressed), or do I need to manually move this code somewhere else on the page?
(NOTE: My Update page is working perfectly, as it is using the recordset ID to generate the name. But I would like to get the insert working as well)