>>That's what I try to accomplish building these cursors, just that I don't have the "flag" field available that's why I have to write some extra lines.
>
>I use a CREATE CURSOR to create the record source, a SELECT and a single scan to INSERT INTO the record source cursor...guess we' end up with the same thing...
>
>j

Ok,Ok... That's rigth, you're Ok

THat is because you still have the information for the inactive items on the items table. You flaged them rigth?

The thing is, and is not my fault, that when a "Scheduler" (item) is fired, or he leaves the company, then the program administrator erases his/her name from the table instead of only flag the name (as you do) as inactive, I know, bad database design, but isn't mine, that's why I have to look for all the possible "schedulers" that worked for the company in the past if there still a record that belongs to them, that's why I have to create an extra cursor from the main table, because there are not on the Scheduler (items) table anymore.

What do you advice?

Cheers!