conditional (partial) merge replication?

Hi there,
I hadn't heard of Merge Replication more than a week ago, so my head's
spinning a bit. It sounds like it is what I'll need, but I'm wondering
if things can be conditionally replicated...
The program I'll be writing is for people at forest fires to keep track of
expenses related to their fire. So I would want them to be able to connect
to the central database, do a merge replication to get all of the
information entered by other people about this fire, and then disconnect
their network cable and head off to the fire. When they return to the
office, I would want them to plug in and update the server again with all of
the information they've generated since then and also get any updates from
other users, etc.
What I do not want to do is have the entire central database downloaded to
them -- just the relevant fire (or two or three)
Is this sort of thing possible automatically? I imagine it could be forced
if need be... but it would be great if it's an easy-to-do thing.
Thanks,
Beverley
Beverley,
have a look at dynamic filters for this; Dynamic Horizontal Filters can be
used to partition data according to the subscriber and rely on the use of
the SUSER_SNAME() and HOST_NAME() functions. Also, in the case of
HOST_NAME() there is a parameter for the replication merge agent -
HOSTNAME - this can be set to be different from the computername, and so
could be a business-related value.
HTH,
Paul Ibison