ok, I'm a bit busy, but I'll point you in the right direction...
if sql sever, look up @@identity in BOL:)
<cftransaction>
first insert with automated row
query to get max id
</cftransaction>
HTH
Tom
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 18, 2004 12:10 PM
Subject: [ cf-dev ] Double Action ....
>
> Another problem ...
>
> I have two tables (I didn't create these so don't blame me ...)
>
> One table (reports) contains reports with a report ID (autogenerated)
> The other (otherinfo) contains other info with a report ID (not
> autogenerated and not indexed etc...)
>
> I need to add a record which will go to the reports table (ok no problem)
> but then also add a record to the other info table with the autogenerated
> ID number which hasn't been generated yet if you see what I mean... A sort
> of double action page ....
>
> I didn't even understand that my self so i'll try to explain better.
> The user adds a report and a record is generated in the reports table.
This
> report has an ID no. Whilst the user was filling in the form other data
was
> collected which will go into the other data table with the report ID.
>
> Any ideas on how I can do this ... ?
>
>
> Regards - Paul
>
>
>
>
>
****************************************************************************
*********************
> The information contained within this e-mail (and any attachment) sent by
Birmingham City Council is confidential and may be legally privileged. It is
intended only for the named recipient or entity to whom it is addressed. If
you are not the intended recipient please accept our apologies and notify
the sender immediately, or telephone +(44) 121 303 6666. Unauthorised
access, use, disclosure, storage or copying is not permitted and may be
unlawful. Any e-mail including its content may be monitored and used by
Birmingham City Council for reasons of security and for monitoring internal
compliance with the office policy on staff use. E-mail blocking software may
also be used. Any views or opinions presented are solely those of the
originator and do not necessarily represent those of Birmingham City
Council. We cannot guarantee that this message or any attachment is virus
free or has not been intercepted and amended.
>
>
****************************************************************************
*********************
>
>
> --
> These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
> Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
>
> CFDeveloper Sponsors and contributors:-
> *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided
by activepdf.com*
> *Forums provided by fusetalk.com* :: *ProWorkFlow provided by
proworkflow.com*
> *Tutorials provided by helmguru.com* :: *Lists hosted by
gradwell.com*
>
> To unsubscribe, e-mail: [EMAIL PROTECTED]
--
These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
