Hi All,

I have one EMPLOYEE.DBF which contains many employee's ID number
EMPLOYEE.DBF
ONE FIELD:(5 CHAR)

EMPNO (employee's id field)

AAAAA
BBBBB
CCCCC
DDDDD
EEEEE
FFFFF
.......

linked to the following tables also dbf extension on the same directory :
AAAAA.DBF, BBBBB.DBF, CCCCC.DBF, DDDDD.DBF, EEEEE.DBF .....

but in the AAAAA.dbf contains 2 fields :
date code
06/20/2000 AA (1 record)
06/21/2000 AB (2 record)
06/22/2000 AC (3 record)

compare with another master table called ABSENCE.DBF with 3 fields

empno date code
AAAAA 06/20/2000 AA (1 record)
AAAAA 06/22/2000 AC (2 record)
AAAAA 06/23/2000 AD (3 record)

How can I insert the (2 record) from AAAAA.DBF in ABSENCE.DBF and vice-versa the (3 record) from ABSENCE.DBF in AAAAA.DBF ,and actually
the two tables should have the same number of records.

The expected results should be :

AAAAA.DBF

date code
06/20/2000 AA (1 record)
06/21/2000 AB (2 record)
06/22/2000 AC (3 record)
06/23/2000 AD (4 record newly inserted)

ABSENCE.DBF with 3 fields

empno date code
AAAAA 06/20/2000 AA (1 record)
AAAAA 06/21/2000 AB (4 record newly inserted)
AAAAA 06/22/2000 AC (2 record)
AAAAA 06/23/2000 AD (3 record)

I'm looking for the fast processing codes to do this because of millions records to be compared and inserted.

Any code's suggestions would be really appreciated and thanks in avance.

Paul