Jen - perhaps you can use a similar technique as I used here?
If you look at my example, and substitute “promotions” for “announcements”, then it’s almost the same. The trick is the dynamically built joined list of UserID’s. That can be used (indirectly) to create a relation back to the Users table.