comparing databases

[Jon]

I'd like to compare the database here in the office to the database that I allow web users to modify and script it so that I can see what files have been deleted by web users, any ideas?

[LiveOak]

Web users shouldn't be able to delete FM files. If you mean "records" instead, relate the two files by a sequential, auto entered record ID. In the related (web) file create a field called Constant (calculation, number) = 1. View this related field from the non-Web file and do a find for Relationship::Constant = 0 (or Relationship::Constant = 1 and omit). This will diplay the records in the non-web file which don't have corresponding records in the web file.

-bd