Is there anyway to set up a transaction log, that will show changes made, who made them, and what date they were made?

Thank you.

Hi Patti and welcome to the list.

What you want to do is called Audit Trail, or Field Modification tracking, and as you might suspect has been discussed in the past. Check out this file by Ray

Comprehensive Audit Tracking System by: Ray J. Cologon AKA http://www.nightwing.com.au/FileMaker/

And these files here:

Field Modification Tracker by: Bob Cusick URL:

http://www.fmfiles.com/tnt2.html

Modification Times by: Alberto Diaz-HermidasURL:

http://www.fmfiles.com/tnt2.html

Tracking Modifications By: Steve Wilmes URL:

http://www.fmfiles.com/tnt2.html

HTH

Lee