VbzCart/queries/qryCtg Titles active

Details

 * Purpose: Brings up only records which are active, making it impossible for an inactive catalog to make an active title look inactive.
 * Requires:
 * History:
 * 2009-05-03 Added to main server database (no change in design)

SQL
CREATE OR REPLACE VIEW qryCtg_Titles_active AS SELECT * FROM ctg_titles AS tgt WHERE tgt.isActive AND ( ( tgt.WhenDiscont Is Null ) Or ( tgt.WhenDiscont>Now )    );