audit field in relationship table

[Ramblin]

Is it possible to audit a field in a relationship table?

If so, how?

I have a custom module, Events which has a many-to-many relationship with Contacts. Like the opportunities_contacts relationship table "contact_role" field, I have an event-role field in the events_contacts relationship table.

I'd like to audit the event_role field.

I entered, into the events_contacts metadata vardef file, after "table" => ... and before "fields' => ... the declaration 'audited' => 'true', and I added to the event_role field definition in that same file the 'audited' => 'true', declaration.

I do NOT get an added events_contacts_audit table added to the MySQL database so I do not have the ability to audit the field.

I want to audit it so I can do SQL queries against it.

I am on SugarCRM CE v 6.2.4

Any ideas?

[rafael.q.g@hotmail.com]

A possible alternative answered here: http://www.sugarcrm.com/forums/f6/au...p-table-77105/