Writing a value to two tables in access 2016

Question

I have two tables in Access 2016 with one to one relationship and I want when entering a value (integer) on the fist one i.e "service report Number" to automatically set it on the second one.

Answer 1

You can use an "update query" to accomplish your need