>>So If I only define a key field for the table I want to update in the view, that's the only table that gets an appended record? Sounds simple enough.
>
>That is correct.
That should be the way that it is, but unfortunately, it's not. Tables listed in the view's Tables property will all get a blank record and often this will cause an error to the effect of "cannot insert an empty row..." because none of the fields are set as updatable.
Jimmy, you'll need to use the view's Table property via DBSETPROP to ensure that only one table is listed.
Erik Moore
Clientelligence