If SQL Server, you could make a trigger on the table to copy the details across when a new item is inserted. If this is a possiblilty then let me know and I will try to explain it.
Ellis C Wood BSc Ellwood Web Solutions T: 01623 459973 E: [EMAIL PROTECTED] W: http://www.ellwoodwebsolutions.co.uk -----Original Message----- From: Tom Smith [mailto:[EMAIL PROTECTED] Sent: 18 March 2004 12:29 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Double Action .... 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] -- 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]
