February 15, 200520 yr Newbies Hy every body, I'm looking for a database who compare 2 tables: I wanna made a database who import 2 tables A and B and compare them. thanks
February 16, 200520 yr This is a schronisation issue. Best to start with the synchronisation rules: decide what to do when the records are compared. Record A is newer than Record B Record B is newer than Record A Record does not exist in A Record does not exist in B And so on. Belive it or no, getting these rules worked out is usually the most difficult part. The synchronisation is technically relatively easy: loop through the records and move data between tables with Set Field calculations. Or perform an import to update the existing records.
Create an account or sign in to comment