I have two tables(a and b) in one access document. And in each table, I have a field[called status](look up field) having the options "Done" and "Done_s". What I want to do is move the records having the [status] "Done_s" to b. This should be done whenever the change occurs. Is this possible? I never used access before and google also does not provide an answer to this.