Hi
I was not specific enough. My primary key looks something like this
RANDI3459 where rand can by GLEN or BOKS and the I can be either I,Q,S or C.
Generator links will definitely not work in this context.

>
> Hi,
> try with TIBOQuery->GeneratorsLink, this property can solve your problem
> without lines of code.
>
> Regards,
> Enrico Raviglione.
>
>
>
>
> Hi
> I have a trigger that generates a unique primary key for my
> table. I set the
> required property of the field to not required so that ibo does not moan
> when I want to post the record. My problem is that I want to display the
> value of this key to the user immediatly after creation. Refresh
> works fine
> but it causes the cursor position to change. Bookmarking this record also
> does not work because when going to the bookmark after refreshing
> I get the
> following error: Record not found. I have also tried
> InvalidateBookmark but
> this also does not have the desired effect.
>
> Here is the piece of code, I have tried it in various orders to get it
> working.
> IBOQPOS_QISC.InvalidateBookmark(S);
> S:=IBOQPOS_QISC.Bookmark;
> IBOQPOS_QISC.Refresh;
> IBOQPOS_QISC.Bookmark:=S;
>
> How do I get the new value of the primary key without loosing the cursor
> position? Would it be better to have a storedprocedure create the table
> entry and return the primarykey value and then doing a refresh
> and locate?
>
> Im using TIBOQuery.
>
> Groete
> Gerhardus