Re: Generating the next sequential key...

From: <timasmith_at_hotmail.com>
Date: 1 May 2006 11:20:03 -0700
Message-ID: <1146507603.184356.85940@e56g2000cwe.googlegroups.com>

I didnt think the autoincrementing column was any use in MSAccess because I need the value generated for child tables and you cant get the value until it is generated - and even then you have to do a lookup to get it (by some *other* unique index since you dont have the pkey yet...eeesh).

Please correct me if MSAccess has progressed beyond that.

Not familiar with SQL Server. As I said above I dont mind coding for a few databases I can test - but I would like to ship a generic solution for all other databases - in which case a or b would probably work though neither is elegant. Received on Mon May 01 2006 - 13:20:03 CDT