>>
1) Loss of context since if you delete a staff person out of the table, you'll also have to delete all tickets that the person has responded to...(think in terms of discussion forums or message boards).
2) Loss of tracking mechanism (similiar to #1, but more mechanical with a bit organic meaning that you will not be able to see who responded to who and who said what to who).
<<
Thats the thing...that wouldnt happen....deleting from the staff allocation table wouldn't require me to delete the tickets the staff member has responded to - deleting from the staff allocation table just means that tickets for the deleted department won't show for the staff member which is what I want.
I guess it's hard to fully understand what going on from a few post so we probably just have crossed wires.
1) Loss of context since if you delete a staff person out of the table, you'll also have to delete all tickets that the person has responded to...(think in terms of discussion forums or message boards).
2) Loss of tracking mechanism (similiar to #1, but more mechanical with a bit organic meaning that you will not be able to see who responded to who and who said what to who).
<<
Thats the thing...that wouldnt happen....deleting from the staff allocation table wouldn't require me to delete the tickets the staff member has responded to - deleting from the staff allocation table just means that tickets for the deleted department won't show for the staff member which is what I want.
I guess it's hard to fully understand what going on from a few post so we probably just have crossed wires.