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
