Create groups based on information from another table


I am trying to set up a database/table where on the first page/table I have all the information set out in various columns/rows and one or two of the columns will be a group or category table.

In these groups you can choose different options, let say, A,B,C,D etc.
I then want to set up a new tables for these individual groups, 1 table per group. When you choose a group or a category for that row, I want certain cells from that row, not necessary all, to be copied into cells in the corresponding table.
So rows that are given group A will all be copied into table A etc. All updates are done in the main table and all other tables get their information from the first table.

Can this be done?

Any help will be much appreciated.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.