I have 2 database files that both accept an address as part of their record but have 2 different functions. Is there any way that I could automate the process so that when entering the details into one of the databases it will automatically create a record within the other database but only if a certain condition is met, e.g. type? I am using Access 2002 and both databases are in 2000/2002 format. Both databases are used as part of a mail merge process so cannot be joined together in order to make the job easier.