>We're having a problem with a datatype mismatch error when running a tableupdate on a view that updates 3 tables.


As a general rule, it's usually a bad idea to have a single view update more than one table (it can pull from as many as you like). You may have a good business reason for doing this however...

To try and debug the problem, you'll want to track down which field or fields is causing the error message- in the view designer or EView, start unchecking the updatable property for each field one field at a time until you an update the view without getting the error. The last field that you remove before the view works is at fault. Check that it's view type is consistent with the underlying field type.