Hi All,
In what was probably a massive bodge, I had a form with a hidden field linked to to an Autonumber ID field in the source table that served as the record's ID and PK. When my users started entering information into the form, this field was automatically updated with the record's ID, which I then went on to use when the user submitted the form to perform some data manipulation before saving the record.
The problem is, that now I have migrated the app's back end to SQL server, this field is no longer populated when the users start entering data, and I suspect isn't even generated until the record is saved and SQL server does its thing to write the record to the DB.
Does anyone have any other suggestions for how I can access the record's ID before it is saved? Now that I type this out I'm realising how much of a bodge this must have been and that there's probably a much better, safer, faster way of doing this.
Cheers,
Phil