Transfering Data Between Databases

i have 3 databases containing data in the same format.

basically i work in a school, and have a database for 3 different classes.

each database has a table containing the childrens details(table a), and a linked table (through primary key in table a) to targets and points scote for each week.

--table a--
child number
name
carer
address
etc

--table b--
index
child number (linked)(displayed as childs name in table, but stored as a number)
week starting
target 1
target 2
target 3
points 1
points 2
points 3
etc


now this database has been working really well. but if ever a child has to be moved class then i need to be called to transfer the records manually (because nobody else can do it) and i have to get the records manually and copy and paste them between databases. This works fine and i've had no problems. And the auto number in table a is changed from the original. but this seems to automatically corrolate to table b when i paste that over. so everything is working fine.
but....
first of all, it creates lots of work for me when kids move classes, and also if i'm not there nobody else can do it.
so....
i've tried using an append query to transfer the data. I tried using 2 append queries (1 for each table).
but....
it works fine for table a, but i'm having trouble with table b.
the append query for table b pastes all the records into the equivalent table on the other database through searching all records related to childs name on table a, therefore retuning all records in table b for that child.
the problem.......
when this data is transfered it transfers table a data fine. but table b is fine except for the fact that it doesn't transfer the childs name data (number), which i can kinda understand, but from what i can understand, my queries are doing the same thing as if i was to cut and paste manually and it works fine when i do that.

ok so its all very confusing, and i hope ive explained adequetly.
oh and btw, i can't put it all in 1 database, because each class may need to access the database at the same time.

thanks


adam