>How exactly tableupdate() updates a table with a new record? Does it insert >or append blank? Is it based on the way a new record was put into buffer?

Don't know how it does it with a VFP table, but when working with a remote server I'm sure that it has to use an INSERT command. My guess is that it also uses an INSERT command for a VFP table also.