Who's On?

	Membership:
	Latest: cat andrews
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5215

	People Online:
	Visitors: 42
	Members: 0
	Total: 42

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
Chesca	1042

AP10.2 Contact Account Number

3 Replies

0 Subscribed to this topic

44 Subscribed to this forum

Sort:

Author

Messages

pglibra

Veteran Member

Posts: 76

New Poster

8/22/2017 12:34 PM

Hello,
I am trying to write an Access query to pull the vendor's account number that can be found in AP10.2, Contact, Account Number.
What tables do I need and how do I link them in Access?

Thank you

Randy

Veteran Member

Posts: 50

New Poster

Engaged Reader

Avid Reader

8/22/2017 12:49 PM

Everything appears to be in APVENLOC Table.

pglibra

Veteran Member

Posts: 76

New Poster

8/22/2017 12:52 PM

Got it.
Was making it more difficult than it was.
Thanks

JimY

Veteran Member

Posts: 510

8/22/2017 1:34 PM

If you also want vendor address information you will want APVENADDR. Make sure you get the current address.