I'm actually working on an almost identical situation. Supposedly you can use subform sets with the appropriate bindings and only the right data will show. I've been unsuccesful so far. Anyone care to offer a suggestion?
Thanks!
Ryan D. Lunka
Cardinal Solutions Group
rlunka@cardinalsolutions.com