how to link 3 subform (tables) together?

[wakamoe]

Hello all,

I current have a form (form1). On this form, there is 3 subforms all taking information from different tables.

child1 - table1

child2 - table2

child3 - table3

All of the tables have the same information. The reason why 3 different tables and subform are being used is because the table has tons of information. Each table shows only a portion of the fields (rest are hidden). However, all tables have the same 2 fields that is shown.

I am wondering if it is possible to link up all 3 tables to that when the user uses a drop down menu on any of the 3 tables, the rest will get filtered as well.

thank you!

 

[JHB]

..
All of the tables have the same information. The reason why 3 different tables and subform are being used is because the table has tons of information. Each table shows only a portion of the fields (rest are hidden). However, all tables have the same 2 fields that is shown...

The concept of a database is not to record the same information/data more than once, so 3 tables with the same data is a no go setup.
You need to read up on database normalization, Google it.
Here is a link to some explanation of it: http://agiledata.org/essays/dataNormalization.html