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,

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