Thanx for the comments... I also work for a great small compagny.  I love the fact that I have plenty of time to hand out here and not hear a...

Any experiences you'd like to share?

Lol, there are so many problems with this design that I wouldn't know where to start... but that's another question for another day !

HTH.

Good point.  My Versions was assuming you needed all employees at the same time.

I thaught about this but it's not accepted.

ALTER TABLE tableName

ADD Whatever INT CONSTRAINT D_CName DEFAULT (dbo.fn_name(ColName))

How about adding the column, then running the update statement right after?

Select * from dbo.Employees E1 WHERE not EXISTS (SELECT * FROM dbo.Employees E2 WHERE E2.HireDate > E1.HireDate AND E1.LName = E2.LName AND E1.FName  =E2.Fname.... /* keep going untill you have...

Select Part_no, MAX(Description) AS Description, SUM(Qty) AS Total FROM dbo.InvMgmt GROUP BY Part_no

This assumes that descriptions is not a very important field in that report, cause you can never be...

On second thaught, you'd be better off gettting the product info from the products table so that you get consistent results.

You can always have 2 unbound text field.  Then on the after_update event (I'm from an Access Background ), validate that you have...

OK, glad to know I'm not going crazy .

No if only those voices could shut up .

Like me... only 2.? years experiences and never had troubles like this one .

Smalldatetime has a precision to the minute (can't store seconds).

Datetime has precision up to 1/333 th of  second (3ms).

I think smalldatetime is the best choice in this case.  The users...