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.