I did some searcing on this, but didn't really find an example of how to set it up for my needs. Someone suggested using this...
select all from mfg
foreach mfg record
print mfg record
select all from items where mfg_mfgid = item_mfgid
foreach item record
print item record
endforeach
endforeach
But I havent found any examples of setting this up either.