Why would you avoid that out of curiosity? Auto incrementing new fields pretty well guarantees that you won't accidentally cause a duplicate. It's quite the standard practice out there from what I understand...
Honestly, you should really be using GUID anyways for most new databases anyways, just in case you need to add replication into the mix. Microsoft themselves are really pusing guids now instead of auto-incrementing fields... Only thing is that that guids are REALLY Long... -----Original Message----- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 12:16 PM To: CF-Talk Subject: Re: Inserting into 2 tables with a relationship 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] > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists