sounds like you have a portal to each affiliate?
if so, you can set a portal filter to only display the current month..
Select Filter Portal Records, then Specify and use this calc:
Month(yourportaltable::datefield) = Month(Get(CurrentDate))
assuming your datefields are defined as type 'date'
Thanks, I'll try that and see how it works out. Thanks for that amazing response time.
So I did it and it works! Not entirely like I visioned, but the important thing is it works. Thank you!