Parent and child tables. How to make sure changes in value in parent table lead to changes in values in child table?
I an a starter and before I worked in MS access. I am missing it. Now I can't find how to solve this problem. I have a reference table which has a unique field and that field is the source for values in the child table. I want to make sure that if I change the value in the parent table, all the values in the related field in the child table should change accordingly. Does anyone knows how to do that?