first pass on transcript relations