Entry in ContSupp to update Contact2 field

[am4ndeep]

Hi Guys

Do you know if it is possible to have something in the lookup.ini where when an entry is put in the contsupp table it will automatically update a field in the contact1 or contact2 field. For example if someone puts an entry in contsupp.title = 'Mr' a field in contact2 would automatically update to 'Male'.

Help would be much appreciated.

 

[richardy]

Not using the lookup.ini.

The only way you could do it is through programming or 3rd party. GoldBox will help do that. Or an SQL trigger or some such.

Regards,

Richard.
PRIOR Analytics UK

http://www.prior-analytics.com/forum/

Sage CRM, GoldMine & HEAT Solutions Partner in the UK