GRD_INTSPEC Grid Component

Purpose

The application administrator uses the GRD_INTSPEC grid component on the ASWSPECLIST.A5W page to maintain the list of products on sale.

[Picture]

Description

The GRD_INTSPEC component is an editable tabular grid based on a view that combines the specials and product tables. The products are listed alphabetically by description. The Description, Qty in stock, Cost, Retail, and List fields are not editable.

Containers

ASWSPECLIST.A5W

Notable Grid Control Property Settings

Control	Property	Description
Product_Id	Display Settings > Validation rules	Cross-file Validation > Data source = "DBF File" Cross-file Validation > Table name = "specials" Cross-file Validation > Field name = "Product_Id" Cross-file Validation > Value must = "Not exist"
Product_Id	Lookup > Lookup definition	Lookup Window > Grid name = "grd_lkprod" Field Mapping > Field map = "Product_id<Product_id, Desc<Description, Qty_stock<Qty_in_sto, Cost<Cost, Retail<Retail, List<List"
Sale_Price	Display Settings > Validation rules	Numeric format > Number type = "Variable Decimal" Numeric format > Thousands separator = "Comma" Numeric format > Decimal separator = "Period"
Sale_Until	Textbox Properties > Date Picker	"True"

Notable Component Property Settings

Note that "/n" generates a line break.

Property	Description
Customization > Confirm message	"Are Sale Expiration Dates Entered? \n\nAre all Sale Prices Entered?"