Thanks Andy for the clarification.

I will definetely read the help file before doing anything.

Just another quick question,

Do the tables have to be linked for a triger to succeed ie...

Thanks Andy,

But will this work even though the two fields are different ie one is a unique number generator and the other is not(it is numberic).

Also pardon my ignorance, but...