cv304
9/7/2017 - 7:29 PM

Marketing Contact Info into Client Invoice Base

Marketing Contact Info into Client Invoice Base

Ajera-clientinvoice-Marketing Contact.sql
content_copyfile_download
Client Invoice Base Widget - Need Marketing Contact and Date Established fields.
Options

‎09-08-2016 01:01 PM

You could pull the marketing contact into the widget using the formula

 

select vecfirstname + ' ' + veclastname from axvec where veckey = (select prjmarketingcontact from axproject where prjkey = [project key])