Set Structure for C:\ALPHA4V4\SPANDIAL\SPANDIAL    

 
Set Tree Diagram       
 
{C:\ALPHA4V4\SPANDIAL\SPANDIAL} -- dialect for spanish study    
 
RESPONSE -- 
   |-----MASTER -- demographic data of Spanish Survery Resp
 
 
                                Link Parameters        
 
RESPONSE ----> MASTER    
	Linked Database/Set     : C:\ALPHA4V4\SPANDIAL\MASTER
	Linking Index           : BYINT_NO
	Common Field/Expression : int_no
	Link to ?               : First
	Include parent if ?     : Always
	Show Mode               : All
	Filter Mode             : Inactive
	Zoom Form               :  
	Browse Form             :  


Parent Database        
 
RESPONSE    
	  Field          Type   Width   Decimal Places    
	 1. INT_NO          C       4        
	 2. ENG             C      20        
	 3. SPANISH         C      35        
	 4. CODE            C      20        
	 5. RECNO           N       6            0
 
 
                                Child Databases        
 
 MASTER    
	   Field          Type   Width   Decimal Places    
	 1. INT_NO          C       4        
	 2. NO_TAPES        C       2        
	 3. LOND            N       4            0
	 4. LONM            N       3            0
	 5. LONS            N       3            0
	 6. LATD            N       3            0
	 7. LATM            N       3            0
	 8. LATS            N       3            0
	 9. DATE            D       8        
	10. CITY            C      30        
	11. STATE           C       2        
	12. INTRVIEWER      C      20        
	13. COUNTY          C       2        
	14. INT_STATE       C       2        
	15. SECTOR          C       2        
	16. URBAN           C       1        
	17. RES_YOUTH       C      30        
	18. AGE_SPAN        C       2        
	19. AGE_ENG         C       2        
	20. ENG_AB_VER      C       1        
	21. SP_AB_VERB      C       1        
	22. CHILD_LANG      C       2        
	23. OTHER_LANG      C      20        
	24. SP_SPOUSE       C       1        
	25. SP_CHILDRN      C       1        
	26. SP_WORK         C       1        
	27. SP_FRIENDS      C       1        
	28. SP_YRS_STD      C       2        
	29. YRS_SP_CNT      C       2        
	30. READ_SP         C       1        
	31. WRITE_SP        C       1        
	32. PREF_SP_TV      C       1        
	33. SPTV_HR_WK      C       2        
	34. PREF_SP_RD      C       1        
	35. SPRADIO_WK      C       2        
	36. ADJLOND         N       3            0
	37. ADJLONM         N       2            0
	38. ADJLONS         N       2            0
	39. ADJLATD         N       2            0
	40. ADJLATM         N       2            0
	41. ADJLATS         N       2            0
	42. LONGDEC         N      11            6
	43. LATDEC          N       9            6
	44. LOCATION        C      15        
	45. LOC_ST          C       2        
	46. PARAGOGIC       C       1        
	47. PALATAL         C       1        
	48. ASPIRATION      C       1        
 
 
Field Rules - Listed by fields for C:\ALPHA4V4\SPANDIAL\SPANDIAL                        

1. RESPONSE->INT_NO (Field 1)    
     Type                          : Character
     Value                         : User Entered
     Default Value                 : Expression
     Default Expression            : MASTER->INT_NO
     Posting                       : No
     Auto Advance                  : No
     Lookup                        : No
 
2. RESPONSE->ENG (Field 2)    
     Type                          : Character
     Value                         : User Entered
     Posting                       : No
     Auto Advance                  : No
     Lookup                        : Yes
     Lookup Source                 : Database
     Lookup Validation Mode        : Exists
     Lookup Exceptions Allowed     : No
     Lookup Location               : 7
     Lookup Display Rows           : 12
     Lookup Auto Popup             : Yes
     Lookup Database               : lexicon
     Lookup Link Index             : byengspn
     Lookup Disp Index             : byengspn
 
                            Lookup Layout
 
Choice Field        Filled Field        Display             Width    
ENG                 ENG                 Y                   20                  
SPAN                SPANISH             Y                   35                  
 
3. RESPONSE->CODE (Field 4)    
     Type                          : Character
     Value                         : User Entered
     Automatic Capitalization Mode : Capitalize entire field
     Mask Override Allowed         : Yes
     Default Value                 : Value
     Default Expression            : 1ST CHOICE
     Posting                       : No
     Auto Advance                  : No
     Lookup                        : Yes
     Lookup Source                 : Table
     Lookup Validation Mode        : Exists
     Lookup Exceptions Allowed     : Yes
     Lookup Location               : 3
     Lookup Display Rows           : 4
     Lookup Auto Popup             : Yes
     Lookup Display Width          : 16
 
                            Choice Table Information
 
CODE                                                                           
1ST CHOICE                                                                 
2ND CHOICE                                                                 
CO-EQUAL CHOICE                                                            
USED AROUND HERE                                                           
                                                                           
 
4. RESPONSE->RECNO (Field 5)    
     Type                          : Numeric
     Value                         : Calculated
     Calculated Expression         : SYSTEM->REC_NUMBER
     Posting                       : No
     Auto Advance                  : No