PMFJI, but sure. Use DBSetProp and set specify the view alias when setting the default value for the field.

>Thanks Trey
>
>I am a bit confused. Is it possible to have default values on views?
>
>>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