I have a one to many relation on a form. The main form contains a grid for the many side. The two are related by a ref number field. The ref number on a new order is temporary when first created. Later a permenate number is assigned. My proble arises when I go to change the number on the form. In the lost focus of the field I run cade to scan for temporary number and replace with this.value on the many side table. It only change one record no matter how many matches there are. Please help.