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 - 16 May 2007 02:56 GMT
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.
> Hello
>
[quoted text clipped - 6 lines]
> Thanks
> Darryl