I suggest using the custom tag... Max_ID from the Macromedia Custom Tag library. It is well documented. Then search the archives for discussions on use of the tag.
I use this exclusively now and avoid AutoIncrementing primary key fields like the plague. hth Brian At 10:49 AM 5/16/02 -0500, you wrote: >I have a database with 2 tables one has a relationship with the other and >when I do an insert I need to insert into table 1 and insert into table 2 >with an var_id field that has not been generated until table 1 has been >inserted into.. I am not sure what to do or how to do it.. I am using CF 5 >and Access.. > >Steven Lancaster >Barrios Technology >NASA/JSC >281-244-2444 (voice) >[EMAIL PROTECTED] > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
