Larry,
It'll also reduce multiuser contention, if you have different people trying to get different keys. Now they all fight for the same single record to get
any key. With one record per key the only contention would be if multiple people need the same key.
>>
>>I recommend the structure changed to cTableName, nKeyValue
>>
>
>Yeah, I was expecting this since I've seen that approach discussed here at length.
>
>But I'm not sure that would solve my problem. Maybe if I SKIP to the next record, that would do it. But then I can do that with the existing structure... Hmmm... I'll give that a try.
>
>Thanks for the feedback