Change number in linked tables

I have database with 18 tables. Table (tblPersonal_Info) is main table
indirectly linked to 7 tablest by relation 1 to many.
This 7 tables have next primary keys:

1/ tblExperience > Pk > 1. Experience code (Autonumber)
2. JMBG (personal identification number) (text)

2/ tblPersonalContact > Pk > 1. NumberCode
2. JMBG

3/ tblEducation > Pk > 1. EducationCode
2. JMBG

4/ tblFamily > Pk > 1. FamilyCode
2. JMBG

5/ tblComputer > Pk > 1. Cognition_of_computerCode
2. JMBG

6/ tblForeignLanguage > Pk > 1. Cognition_of_Foreign_LanguageCode
2. JMBG

7/ tblDevelopment > Pk > 1. DevelopmentCode
2. JMBG

When I add new record into main form I have no problems. Now if I want to
change JMBG in existent record in main
form, I can do this but old JMBG stay in other 7 tables.
I want when I change JMBG in main form automaticly changing in 7 others
tables. Can I make some update query or something else.
If you know couple solution, please let me know so I could find out what is
the best for me.

Thanks a lot.

Re: Change number in linked tables

ANSWER wrote:
> I have database with 18 tables. Table (tblPersonal_Info) is main table
> indirectly linked to 7 tablest by relation 1 to many.
> This 7 tables have next primary keys:
>
> 1/ tblExperience > Pk > 1. Experience code (Autonumber)
> 2. JMBG (personal identification number) (text)
>
> 2/ tblPersonalContact > Pk > 1. NumberCode
> 2. JMBG
>
> 3/ tblEducation > Pk > 1. EducationCode
> 2. JMBG
>
> 4/ tblFamily > Pk > 1. FamilyCode
> 2. JMBG
>
> 5/ tblComputer > Pk > 1. Cognition_of_computerCode
> 2. JMBG
>
> 6/ tblForeignLanguage > Pk > 1. Cognition_of_Foreign_LanguageCode
> 2. JMBG
>
> 7/ tblDevelopment > Pk > 1. DevelopmentCode
> 2. JMBG
>
> When I add new record into main form I have no problems. Now if I
> want to change JMBG in existent record in main
> form, I can do this but old JMBG stay in other 7 tables.
> I want when I change JMBG in main form automaticly changing in 7
> others tables. Can I make some update query or something else.
> If you know couple solution, please let me know so I could find out
> what is the best for me.

Go to Tools | Relationships, and set the table relationships to include
cascading updates.



> Thanks a lot.