Hi Michael,

>How do i determine the key field? Does it have to be a unique id value?

Yes the key field does need to be unique. You can use an ID field that is used JUST as a unique key.


>
>Could you better explain that last part? I get from it that before i use the =Requery() that i should use TableUpdate (on the view?) I don't understand what you mean about updating the tables after updating the view. (tableupdate(view), then tableupdate(maintable) then =requery(view)?)

Yes, this is a bit confusing.

If you open ONLY the view MyView in your code, then VFP will also open the table MainTable which is the table the view uses in its design. However, the view will NOT be buffered.

However if you USE MainTable and then USE MyView, MainTable may be buffered, depending on how you've set your form and data environment.

IF MainTable is buffered, then your scenario is correct:

TableUpdate(2,.t., 'MyView')
TableUpdate(2,.T., 'MainTable')

Requery('MyView')


>I'm sure by now UT'ers know that PBP trains developers by making vague requests and then pushing up the deadlines. Thanks again for all your help.

Believe me, PBP is not the only company doing this. My own consulting company just had its head developer (me) revolt against the unrealistic deadlines demanded by the president (also me) < grin >

Barbara