Hi, hope someone can help,
In order to make all my records unique I have adopted a job reference which incorporates the ID of the record as part of it.
I have a field in my form for job reference and it creates a value which consists of the record ID reference / the property address / our error code
What seems to be happening when I save the form is that the job refernace which should look something like 34/254/E5 is coming up as /254/E5 so the field is saving the value of the property address “245” and the error code “E5” but it seems to not be able to get the reference ID until after the record has been saved once using ‘SubmitForm’
Is this because the ID reference of the record isn’t issued until the form is saved?
Once the form is saved you can see the full reference in the files, but you have to press save again so that it writes it too the data source.
I have tried SubmitForm(formname);SubmitForm(Formname) but I just get an error.
Is there a way to update the record, before the form is submitted so that the job reference is written to the data source correctly first time?
Sorry if this doesn’t make clear sense, found it hard to explain what I’m trying to achieve!
Thanks
