I've been evaluating ASPRunner and have a question about limiting what a user can see. Here's an example of what I'm trying to do:
We have a simple table containing cost information. Each record includes a "Cost Center" field to indicate where things will be charged. Within the organization, one individual may have responsibility for multiple cost centers.
Using the security featres, I can limit a user to seeing a single cost center by including a Cost Center field in a security table and matching it to the Cost Center field in the data table. But how do I allow an individual to see all the records containing the cost centers they are responsible for?
Here's a table example:
Cost Center, Cost, Description
-----------------------------------
AAA 100.00 Whatever
BBB 200.00 Whatever
CCC 300.00 Whatever
DDD 400.00 Whatever
An individual user needs to see AAA and CCC, but should not see BBB or DDD. A different user needs to see AAA and BBB but not CCC or DDD. And so on ...
Thanks for your help!
