Ouch! Thanks. I stand corrected, I missed the VFP part, sorry.

I don't know what the equivalent of a SCOPE_IDENTITY is in VFP (or even if there is one). I suppose if this were done with a stored proc and wrapped inside a transaction, you could get the most recently generated key inside the stored proc...though how full-proof that is, I'm not sure.

Thanks,
Kevin