Hi All;
I'm working on a report for my development dept. and I need to get an email address out of the system with a specific contact purpose we have entering in to their record. I haven't figured out where the contact purpose is tied to the email address to pull the information out of the database.
I'm sure others have run into this problem and I'm wondering how they handle it.
Any advice would be much appreciated.
Joe Shafranek
jshafranek@westportplayhouse.org
Hi Joe,
A purpose is tied to the eaddress_no in TX_CONTACT_POINT_PURPOSE where it is called contact_point_id.
Cheers,
Kevin