Who's On?

	Membership:
	Latest: Jeffin Joy
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 4988

	People Online:
	Visitors: 214
	Members: 0
	Total: 214

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

Crystal Reports - Link ICTRANS with APVENMAST

3 Replies

0 Subscribed to this topic

40 Subscribed to this forum

Sort:

Author

Messages

Alicia

New Member

Posts: 0

10/6/2014 7:16 PM

I have a Crystal Report which consists of ICTRANS fields. I need to pull in the Vendor Number and Vendor Name associated with the ICTRANS Item Number. The APVENMAST table contains the Vendor data that I need. Is it possible to link ICTRANS with APVENMAST (or some other table) to get the Vendor Number and Name? FYI, currently, the Crystal Report consists of the following tables: ICITLUF, ICMXVAL, ICTRANS, ITEMLOC, ITEMMAST.

JonA

Veteran Member

Posts: 1163

10/6/2014 10:17 PM

You're on the right track. Try adding ITEMSRC (connect to ITEMLOC) . Connect APVENMAST to ITEMSRC.

Alicia

New Member

Posts: 0

10/7/2014 1:35 PM

Ok, I will give it a try. Thanks, Jon!

Alicia

New Member

Posts: 0

10/7/2014 7:32 PM

Thanks again, Jon! I was able to get the link to work as you suggested.