Append query help needed

  • Thread starter Thread starter Corinne
  • Start date Start date
C

Corinne

I have a database of pupils in school. When a pupil
leaves I run an append query to put them in another table
called 'off roll'. My problem is that I have several
tables that are related to the main table. Two questions
how do I append the data that is related to the main
table for the pupil off roll? Secondly occaissionally a
pupil will return to school and the data needs to be put
back in the main table, is this possible to do and if so
how?
Many thanks for any help you can give.
 
Why not add a flag field 'off roll' and add criteria to
queries not to pull with this flag.
 
Back
Top