Hi all,

Thanks for the initial responses. I think I explained what I was looking at
in the wrong way. The answers help a bit, but the situation is a little
different than what I believe I was able to express. I'll try to explain the
scenario a little better below.

Let's use Sales people as an example.

I am Joe, a sales person for widget dealers. There are 20 other sales people
on the sale force. We're all responsible for managing how many widgets are in
stock, how many have been sold, and the people we've sold them too.

This is the situation. I come into work on Monday. I log into the system, I
have a subscription to the application that says "give me a listing of all of
the widgets I've sold since the last time I logged in, and who I sold them
to." That's the easy part.

The difficult part is this. I also can manage and review sales data for 10
of the other 20 sales people. So, when I log in, not only do I have to
retrieve all of the updated widget sales for myself, I also have to retrieve
all of the updated widget sales for the other 10 sales people that I have
access to.

So, really, my question is how best to manage that from a subscription
aspect. Do I have one subscription with a massive event rule for matching?
Multiple subscriptions for every other sales person that I am somehow an
associated subscriber to on top of my own subscription? Manage it someway via
tables in the database? Or some other method.

At the moment (pre-SQLNS), we manage this application by storing a 'group'
table in the database, which has one ID for the group, and a listing of all
of the sales people IDs in that group. When we go to retrieve the data, the
first thing we do is create a temporary table that is filled with all of the
IDs for the group the logged individual is in, and then parses through each
ID in that table to retrieve the relevant data for each person before
returning the entire data set to the individual that is logged in.

Thanks again.