Micheal;

THe following should provide a clearer picture of what we are trying to do.

STUDNT to STCORS is a 1-n relationship. One Student with zero or more class.

File Structure
	STCORS has fields CSCHOOL, CSTUDNT, CUNIQUE, etc.

	STUDNT has fields SCHOOL, LOCAL, SURNAM, FIRST, etc.
	STUDNT has key file named STUDNT and is segmented 
		using SCHOOL and LOCAL.


We would like to scan STCORS and select all classes when CUNIQUE=11231
Since CSCHOOL corresponds to SCHOOL and CSTUDNT to LOCAL we would like to 
extract SURNAM and FIRST into the tag file and thus produce a nice listing
that is alphabetical (most teachers like class lists this way).


Any suggestions or examples to clarify the syntax would be much appreciated!


Thanks,  
	Barry
;
;	Example
;
primary file COURSES named STCORS notag
	display progess statistics on row 7
	alias CSCHOOL with SCHOOL
	alias CSTUDNT with LOCAL
	select when CUNIQUE="11231"
end
;
child file STUDENTS named STUDNT
	related to COURSES as only child by LOCAL STUDNT
	extract SURNAM, FIRST
	sort by SURNAM, FIRST
end

.