here is our dilemma - we want to store all our news items in a common repository so they can be shared across brands and locations
//SERVER/default/main/common/WORKAREA/Content/templatedata/pr/news
i.e. a PR person could fill out a news article, flag it for multiple brands and locations, and push it thru the workflow.
the PR user would have access to all the options in the dropdowns.
the issues are
- the drop downs need to be dynamic (i.e. user picks brand A, the location dropdown can only show locations applicable to brand A)
- the drop downs need to be pulled from a pre-existing table in a SQL server 2005 db
- certain users would only have access to certain brands/locations in the template (how would we do this?) i.e. a philadelphia PR person should use the same template but only see the philly options. could this be done via TS groups somehow?
any help would be greatly appreciated - thanks in advance
[HTML]
[/HTML]
