Welcome, Guest
Username: Password: Remember me

TOPIC: Retrieve Supplier Name from Macola

Retrieve Supplier Name from Macola #2815

  • vss7121
  • vss7121's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
  • Karma: 0
Are there any examples of best way to retrieve Supplier Information from the Macola Purchase Order Table and insert the Macola Supplier Name into a WebPage Form Field? (after entering a specific PO Number).

Trying to think of best methods and methodology.

Thank you,
The administrator has disabled public write access.

Retrieve Supplier Name from Macola #2823

  • dgillz
  • dgillz's Avatar
  • OFFLINE
  • Platinum Boarder
  • Posts: 395
  • Thank you received: 14
  • Karma: 6
It is no different than Progression, except apvenfil_sql is a view, not a table. Here is a simple SQL query to do the trick, add you own WHERE clause and other fields that you may need:

SELECT poordhdr_sql.ord_no, poordhdr_sql.vend_no, apvenfil_sql.vend_name
FROM poordhdr_sql LEFT OUTER JOIN
apvenfil_sql ON poordhdr_sql.vend_no = apvenfil_sql.vend_no
www.gainfocus.biz
Worldwide support for Macola Progression, Macola ES, Synergy, Event Manager and Crystal Reports.
The administrator has disabled public write access.
The following user(s) said Thank You: vss7121
Time to create page: 0.032 seconds
Powered by Kunena Forum  Protected by R Antispam