Hi,
I have a problem with modify a filed in a query "Datasheet view".
Database is attached please find it.
Problem is when I try to modify a value on occupation field, the data on table 2 will change and all fields will change ! ( you can test it by open query1 and change welder to anything else you will see all welders in any row will change!) I need to that change apply in a table1 only for specified row that I try to change the data.
For example I change the Arvin Baba occupation to Singer and only arvin baba occupation change.