Re: Getting a serial index back

Jeff Pickett <pickett@telerama.lm.com> wrote: > > Ok, this has got to be an easy one for the majority of you. So > here it is: > > I have a header record with a serial index on it, so after I > insert the header record into table 1, I would like to know what > that serial number is so I can put it in the detail record I > am about to insert into table 2. > > So how do I find what serial number was just used? > <snipped>> Ok - this is probably a hack, but it is what I did when faced with the same necessity. I selected the *indexed column* from the table using the header's unique keys following the insert and stored it for later use.