How are the two tables tied together (using foreign keys?) Without
the schema, it's hard to know what might be going on.
Stephan Szabo
sszabo@bigpanda.com
On Thu, 17 Aug 2000, Fetter, David M wrote:
> I hope I can explain this so it is understandable. I have an object within
> a table which has a variable type of 'timestamp'. This is the close_date
> for an in-house ticketing system. It has a relation to another table which
> has the listing of all of the administrators. The problem is that if one of
> the administrators leaves to go to another job and then we remove them, the
> timestamp value associated with all of the tickets that this admin has
> closed loses it's value. So, now we don't know when the tickets or tasks
> were completed from the past. I tried re-adding the admin but the
> timestamps do not return. I figure we probably lost the data, but I don't
> really want to lose it again. Has anyone come across this problem? Does
> anyone have any idea as to how to correct it?
