>I have a view open in the DE made up of 3 tables. If I append a new record, but only enter data for one of the tables and issue a tableupdate(), what happens.........?
>1. Just that table gets a record appended
>2. all tables get records appended, two of them blank
>3. update errors occur
>
>Thanks
>JD
If you make all 3 tables updatable and have defined Key field for all three, then all 3 get a new record. So, however many of the tables in the view you have defined a key field for get updated.
Mark McCasland
Midlothian, TX USA