You can set the v_ticket.p_ticket field's default to NextKey().

>I have a table TICKET
>It has a primary key called P_Ticket
>
>I have an indexed view onto this Table called V_TICKET ( CURSORSETPROP("Buffering",3) )
>
>To insert a record I am doing the following
>
>*I insert a record into v_ticket
>
>insert into v_ticket (ticket) values (myValue)
>=tableupdate(.t.)
>
>* This triggers NextKey routine which now generates a primary key for me
>
>At this point I have a primary key in my TICKET table but I do not have a Primary key in my V_TICKET view table.
>
>Since I need this key to be in my view I populate the view primary key as follows
>
>REPLACE v_ticket.P_ticket WITH giPrimaryKey && giPrimaryKey gets set when nextkey() is run
>
>* if I now do a table update (to be on the safe side)
>=tableupdate(.t.)
>
>at this point my update fails with update conflict.
>
>I realise that I can do a REQUERY() instead of the above REPLACE but it is very inefficient to do this at this point.
>
>Please advise me if there is a solution to this problem.
>
>(Using Tableupdate with the lForce set stops the update failing but this is not desirable)
>
>Many Thanks