Hi ,
I have a problem.. i need to make sure that i should stop users from entering records inot table that have the date fields in the past...
I tried inserting a constraint to do this.. but the constraint says that the records that already exist do not follow the rule.. i thought about a trigger.. but how can i find the record i want to insert using a trigger because there will already be records that have date in the past.. and i dont want to use any client side checking.. want it to be in the database itself..
thanx in advance