Sunday, February 12, 2012

Constraint or Trigger

Hi Guys,

I am not sure if this is the correct forum but i thought i'd ask and see if you can help me!

I have a table with 2 columns:

1st column will house numbers from 1 to 50

2nd column will be date

I want the users to be able to pick a number for certain date and enter it to the table, however I don't want the system to allow the same number for the same date. I was looking at constraints and triggers but can't make out what exactly i should use and how. The Insert will be initiated from ASP page on our intranet. Please help!!!

Regards

SD

See responses to your question in the Tools Forum.

No comments:

Post a Comment