>> That's a little bit confusing, but may work... Do you see other
>> possibilities here?
>
>
>what if you didn't use two set of tables in the first place, but
>rather used only one, and added a field to indicate archived or
>not. then just filter on that field. or create 2 views.
>
>(i suppose that might not be a good idea if you had a LOT of jobs
>and were moving the archived ones to keep the active job table
>from growing without bounds.)

Yes on your second thought. So, the first idea would not work :)