I have a Location Office table, I recently changed a Licence Number column, it supposed to only add this information to the new records instead it also changing the Licence #  from pass records, I would like to know if maybe you have some suggestions of what could be wrong.

---

Reply from Alex Hedley:

If you change a Field in a Table then it changes for all.
If that Field is bound to a Form then you can update an Record in your Table.