I'll try again, a previous post has not gone through yet ...

Andreas Bednarek wrote:

>>Really, you shouldn't be using a technique like this with a client/server
>>database at all:
>>a) it should be done on the server
>>b) the keys should not be dependendent on one another's values
>
> Thanks Helen, but I need to now the key value of the (possibly) new record
> to keep track of what record should be updated later if needed. Table1 is
> used to store some settings which may or not be present.

Use the GeneratorLinks with a generator, and IBO will manage
it automatically for you, and give you the number to allow
you to follow up.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services