My select statement to generate the DBGrid in VB6 contains a join from the data table to the reference table so descriptive text is displayed instead of a code number. When I change the text entry (via a dropdown from the appropriate column - button property set to true) the reference table is updated as well as the data table. Does anyone know how I can stop updates to the reference table?