I have a database called Last_Contacted.FP5 that contains these key
fields (Along with many others):
Each time the user contacts this company, the Last Contacted date is
updated for the date that the record was altered.
What I am trying to do is to run a script that will look at the "Current
Date" and match it to the Last Contacted date. If the
dates match, then I want it to copy all of the data elements listed
above to another database called. Records_Updated_History.FP5.
How do I do this ?