Hi, I have a table "Sales", where I have the fields "date", "location" and "points". The field "date" internally tracks the date of entry using the function date(). The other two fields have to be entered by the user. I need help whereby on a particular date; for a particular location the points can be entered only once. If the user tries to enter the points for the same location on the same day; it should show an error message. He can enter points for that location only the next day. That is suppose for a location "Texas" for date "1/27/2004" there can be only one entry. Can anyone please help?