Maxi Merge With Relationship

[kigor]

Hello,


I have one old Ms Access 97 program that go to change and "modernize"

It have generally four table.
Table 1 and Table 2 are input one with general staff
Table 3 are in relationship with Table 1 as one to many
Table 4 are in relationship with Table 3 as one to many, but also with Table 2 as one to many.

Thi is simple part.
Problem are that for Table 2, 3 and 4 I have 10. So 10 table 2 (with different staff of course), 10 table 3 and 10 table 4.
But all Table 2 have identic Field name and all field name are of identic Data type. Identic for Table 3 and 4.
Table 1 are connected with all this 10 table(s)

What I am looking for is the best way to merge all table 2, in just one table 2. This also for Table 3 and Table 4.

so from now 31 table to have in the end just four table.

What you suggest me to do, or better how to made all this merge and to mantein all this relationship.

Any idea is very welcome

[NTC]

well it is very strange to have 10 table X.

to merge them together is by doing a one time AppendQuery table by table. i.e. adding 2 to 1, then 3 to 1, then 4 to 1, etc.

it actually is quite easy.

[kigor]

Hello,
thanks for your replay. Yes I know it strage start but I update old program with bad "politics". In the end I resolve this problem in big part in Excel. The big problem was have in the end all relationship working