The first think that comes to my mind is to REQUERY the view after TableUpdate(). Unfortunately nothing else :o(((
>Hello All,
>
>I've got a mentoring client who is having a problem with LOCAL VIEWS and auto-increment fields in VFP 8. Since I haven't worked with the auto-increment fields in VFP 8 yet, I come here looking for help!
>
>USE vCustomer NODATA && assume two fields PKID (auto-inc) and CompanyName
>CURSORSETPROP("Buffering",3)
>APPEND BLANK
>
>* At this point the PKID field in the view has 0 and that makes sense
>
>REPLACE CompanyName WITH "TakeNote Technologies"
>
>After a TABLEUPDATE(0) the parent table shows the new key value but the LOCAL VIEW does not. What is the best way to get that value into the LOCAL VIEW? Something like this?
>
>vCustomer.PKID = Customer.PKID
>
>Thanks!
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.