Updating a view is similar to issuing a sql select command with the where clause; this is how VFP finds the correct record or records. Checking the no duplicates button should be comparable to using the distinct keyword; in this case it just grabs the first record it finds although I've never used it myself. Therefore for performance reasons use as few key fields as possible to insure a unique record and make sure you have coresponding index tags on these fields and select the key fields only or key fields and timestamp option if possible, otherwise VFP may generate a long sql statement and you may get the 'sql where clause too long' error and have to use sys(3055) to execute.

Randy Barber