On Tue, Nov 11, 2008 at 7:40 AM, Ajoy Khaund <akhaund@gmail.com> wrote:

> Dave Thanks and also to Maurice.

>

> This field is not a very important field. In a employee table permanent

> workers have a Provident Fund Number which the temporary guys don't have.

> Now I have to have check when saving the record to confirm the number does

> not exist.

>

> Where would you put a check normally.

----------------------------------

I would validate that # before I did the row insert. Is there a high

velocity on inserts to this table? If so create a trigger for insert

to gen it at insert.

--

Stephen Russell

Sr. Production Systems Programmer

Mimeo.com

Memphis TN

901.246-0159