Thanks Sean, that answered my question perfectly!!!
Scott
>
> http://www.teamallaire.com/tutorials/maxID.cfm
>
> ___________________________________________
>
> Sean Brown <[EMAIL PROTECTED]>
> http://www.westcar.com/
>
> "Either way you get your dog back"
> -Anonymous
> ___________________________________________
>
>
> -----Original Message-----
> From: Scott Forler [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 09, 2000 7:27 PM
> To: [EMAIL PROTECTED]
> Subject: autogenerated keys
>
>
> Hello All:
>
> Is there a way to determine the auto-generated primary key generated by
> Access when using CFInsert? I am trying to create two records, one that
> creates a key (auto numbering turned on) and another that uses
> the key that
> was just created.
>
> I suppose I could save a unique predetermined key at the same time as I
> create the first record and use this to query the table for the
> value of the
> autocreated key but this seems like a forced solution. Is there a better
> way? Am I going about this wrong?
>
> Thanks,
>
> Scott
>
> PrairieWeb Internet Marketing, Inc.
> Web Development and Marketing
> Phone: 630-393-1419 x11
> Fax: 630-393-1487
> http://www.pwim.com
>
> ------------------------------------------------------------------
> ----------
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
