Let's say you want certain accounts to be available for posting only with particular departments. Out of the box, I don't think you can do this: an account is either available for all departments or for a single department (or class, location).
First, am I missing a basic config setting? Is this really the case? What we're after is basically a multi-select instead of a single select on the Department/Class/Location Restriction fields on the Account record.
Next, how about implementing restrictions among Departments and Classes (and Locations), e.g. Class "Textiles" is only active for Departments, X, Y, and Z?
Assuming neither of these is possible with config, how good or bad are the scripted or workflow solutions?
Thanks,
Evan