>I have a form with controls which are bound to 2 tables. When I do a tableupdate it will obviously update both tables. The fields that are bound to table1 do not need to be updated. they are only to show the information and are disabled.
>
>Therefore I know they cannot be changed but at the same time I dont want to update the record as this is just wasted processing time as I see it. Can anybody help me. Many Thanks
TableUpdate() updates ONLY one table, Table opened in current alias or that table/alias specified in 3th parameter of TableUpdate(). You can't update 2 or more tables with a single TableUpdate()
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.