>>>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.

So would this do the trick.......

DBSETPROP("intrancust", "view", "Tables", "inventory")
=TableUpdate(.T.)

Thanks
JD