I have a table(Master) with students name and class (let say 5a, 5b, 5c). I want to create a table(5a) for students of class 5a only. However, when i update the master table, this should reflect on the 5a table. The 5a table will have other fields that are not in the master table. I can run a make-table query but that does not solve the problem of update and keeping the data in the other fields. Help deeply appreciated. I am stuck on this for 2 weeks now!!!