CiviCRM Community Forums (archive)

Forgive me if this is already possible but I can't find it any where if it is.

We have a state organization comprised of local county chapters.  What I would like to do is have each county org to have its own crm db that feeds the state DB.  That part I could probably do on my own (just scrape the db's every so often).  But the tricky part is I'd like the state DB to be able to feed its updates back to the counties.  This is particularly important for when members move throughout the state. 

If there are really good reasons for separate databases then ignore this, but I think the way to go is to have just the one CiviCRM set up and use the access controls to lock the system down so each sub-region only has access to members in their area. This is how we have implemented it for a national organisation that has 'chapters' all of whom need access to 'their members'.
We have set up 'manager groups' for each of our regions (not Smart Groups but we can run a cron to keep it uptodate on a daily basis) and then have SmartGroups for all contacts in region A, B and C.
The Managers for A then have view/edit rights to members in A, and Managers in B for B etc..
And of course national Managers have access across the whole scheme.
Hope that helps