OK, let's do a real simple update and see what happens.<br><br>Let's assume that the data in Contact (your Navision table) has changed and that the table it needs to change on your server is tblServer.<br><br>You have X number of fields in Contact, but only Y need to be used to update tblServer.<br><br>Add both tables to a query and join the tables by SalespersonID. Change the query to an update query. Double-click on the Y number of fields fields in tblServer that need to be updated. That will move them down to the qrid. The thrid row of the grid is Update To. On that line, enter the name of the field you want to use from Contact to update the respective tblServer field. Use the form [Contact]![YourFieldName]. You will have a value in each column.<br><br>To do this as a test, you should make copies of the tables. Actually in your case, do an import instead of a link on the two tables. That will create stand alone copies of the tables, and if you keep the same names when you actually link them, then the query will work seamlessly. Just a thought.<br><br>You can limit your update to one record, by adding the SalespersonID to the query and enter and ID number on the fourth line, the criteria line, of the grid. <br><br>Let me know what happens. If it doesn't work, let me know and I will send you a sample Access db off-list with an example.<br><br>Kathryn