Link Customer table to CustCnt table via:
Company ---> Company
CustNum ---> CustNum
PrimaryPCon----> ConNum (note this is for Primary Purchasing contact)
There are also PrimaryBcon (billing) and PrimaryScon (shipping) options. Contacts on customer have to be check marked as being the primary for these functions.
I'll send an example label report off-list.
-Todd C.
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Darren
Sent: Friday, February 23, 2007 10:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] <Report Builder> Feels like Monday...
I've had a terrible week. I'm hoping someone can help me here.
Trying to create mailing labels for all customers who have purchased
more than $2000 from us in any of the last 3 years...I've got that
part working!! Now they throw in the part about sending to each
customers primary contacts. Can anyone provide me some direction? I
know it should be a piece of cake. I'm sorry for my stupidity, stress
is clouding my thoughts...lol TGIF!!
Vantage Version 5.2
Thanks,
Darren Mann
Miller Products Co.
[Non-text portions of this message have been removed]
Company ---> Company
CustNum ---> CustNum
PrimaryPCon----> ConNum (note this is for Primary Purchasing contact)
There are also PrimaryBcon (billing) and PrimaryScon (shipping) options. Contacts on customer have to be check marked as being the primary for these functions.
I'll send an example label report off-list.
-Todd C.
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Darren
Sent: Friday, February 23, 2007 10:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] <Report Builder> Feels like Monday...
I've had a terrible week. I'm hoping someone can help me here.
Trying to create mailing labels for all customers who have purchased
more than $2000 from us in any of the last 3 years...I've got that
part working!! Now they throw in the part about sending to each
customers primary contacts. Can anyone provide me some direction? I
know it should be a piece of cake. I'm sorry for my stupidity, stress
is clouding my thoughts...lol TGIF!!
Vantage Version 5.2
Thanks,
Darren Mann
Miller Products Co.
[Non-text portions of this message have been removed]