10.1 -  Data Window

10.1  Data Window

 DataWindow

 DataWindow  dw_master  Quick Select   Employee   DataWindow dw_detail  DataWindow  Employee ID  Employee 

 Data Source  Style
 Table  
 Retrieveal Argument
 Where Clause

 Data Source  Style
1.  DataWnd  PowerBar
DataWindow Painter  Select DataWindow   d_head  DataWindow

2.  New
 New DataWindow 

3.  SQL Select  Data Source
4.  Free form  Presentation Style
 OK
 Data Source  SQL Select  Select Painter 
 Select Tables 

 1  New Data Window

 Select Painter  Table  Column

5.  Employee  Table

6.  Open

 2  Select Table

7. 
id,fname,lname,status

 Selection List

 3 

8.  Retrieval Argument
 Design > Retrieval Argument 
 Specify Retrieval Argument 

9.  emp_id  Name
 Number
 OK

 4  Retrieval Argument

 5  Specify Retrieval Argument

10.  WHERE Clause
 Where Tab Where Tab 
 Column 
 >>  emp_id

 6  WHERE Clause

11.  Value
 Popup 

 7  Popup Menu

12.  Arguments
 Arguments   emp_id
 Paste  6
Where Tab  Retrieval Argument  9

13.  SQL Data  PainterBar  DataWindow Painter

 8  Argument

 9  Argument

14.  Edit >> Select >> Select All    Ctrl + A
 Data Window 

15.  Style Bar  MS Sans Serif  8

 8  Fonts  Style Bar

16. 
17.  emp_status  Properties  Popup Menu

 9  Column Object

18.  Edit
19.  Style  RadioButtons
 Display Value  Data Value  Active  A  Add  Inactive  I

Display	Data Value
Active	A
Inactive	I

20.  OK   Detail  Department   13

 13 

TOC