Using a new record ID before an item is submitted

[DarrylGould]

Hello

I have an IP form which links to a SQL database. I want to make a
field equal to the records ID, i.e. ID = fieldA, however, as IP
doesn't know the ID of the record until the form is submitted to the
database, how can I make fieldA equal to it?

Any ideas
Thanks
Darryl

 

[Art]

does the record exist in the SQL table or is it a new record being created?

If a new record you can query the database and look at the last ID but what
if two forms are opened at the same time?

In reality, I do not think it can be done.