Hi everybody,

I would appreciate your insigths on the problem I'm facing. I want to distribute work between employees. The parameters of this process are not yet defined and set up, we're going to change our tables to accomodate business requirements. The basic criteria could be: product line(s), specific client(s), patient's last name first letter, etc. Right now I set up a view to get all unassigned work and then I'm doing a scan to assign work to employees. I'm thinking about several possible solutions:

1. Set up a view to reflect employee's profile. Then my main view should be re-designed this way:

select ... where Trans_Pk in (select Trans_Pk from employee_profile's view). This idea is not going to work because of our naming convention.

2. Set up a view to reflect employee's profile. Then create a string with all IDs (our ID is char type). How should I design my main view to use this string of IDs?

3. Have a main view without restriction on Trans_pk. This way it could produce lots of records. Is it dangerous?

What would you suggest?

Thanks a lot in advance.