maintaing relationships in multiple tables after append query

[plantfinder]

I have two tables, Plants and Photos in my database.
I have an autonumber index ID field for each table.
Photo records are linked to a specific plant record by the Plant ID # contained in a field in the photo record.
I have data being gathered and entered on a computer in 2 remote location into these tables in identical Access Databases. I now need to put any new information gathered in these locations and enter it into a master Database.
I have no problems appending data into the master database but I cannot figure out how to maintian the relationships between specifc records so that the same plant records in the master database are associated with same photos as the were in the remote databases.

Please help. It would be greatly appreciated

 

[mikey69]

I don't much like Microsoft's replication feature, but this is one situation where you might consider using it. I think you might find the alternatives very arduous to maintain. Read about replication in the help file.