I was thinking triggers were tied to specific fields in specific tables. With a large relational database, hundreds of tables, if a user makes a change to one field in one record wouldn't it be hard to set up triggers for all of that?

Yes I should get more detail because if this is a client audit requirement or SAS 70 type requirement it will have to be bulletproof.