I'm using an example I found to sync a ce database with a sql server db using
replilcation (publications). How do I tell the publication that I only want
certain results based on the identity of the ppc user....For example, How do
I get the ppc to say 'hey, I'm salesman #5, only give me customers out of the
main customer file that belong to me.'?

That's a function of your publication. The subscriber must pass info to the
publisher in the subscription request (like userid) and the publication is
then horizontally partitioned based on that criteria.

-Chris


"theKirk" <(E-Mail Removed)> wrote in message
news:0F048973-1B88-482F-AEA2-(E-Mail Removed)...
> I'm using an example I found to sync a ce database with a sql server db
> using
> replilcation (publications). How do I tell the publication that I only
> want
> certain results based on the identity of the ppc user....For example, How
> do
> I get the ppc to say 'hey, I'm salesman #5, only give me customers out of
> the
> main customer file that belong to me.'?