VbzCart/queries/qryCbx CustNames

About

• Purpose: Provides a list of customer names with associated cust_name IDs
• Requires: cust_names
• Used by:

1. REDIRECT Template:l/vc/query

• History:
  • 2009-07-09 Copied from MS Access version

SQL

<mysql>CREATE OR REPLACE VIEW qryCbx_CustNames AS SELECT

 ID,
 Name

FROM cust_names ORDER BY Name;</mysql>