Lowell,

The problem I was having with the Staff table was that every time a record was added and saved, the 2 generated fields by the trigger were blank, which to...

Lowell,

thanks, I will update the trigger to use the INSERTED table and retest to see if the trigger fires every time.

Kevin

Lowell,

Sorry, didn't see your inserted code? Would using the INSERTED table get the trigger to fire each time?

Lowell,

Thanks for the reply. Since I"m knew to SQL, I'm unfamiliar with how to work worth the inserted table. How would I modify my code to use it?...

SSCrazy, sorry for the miss spell of name 😀

I think we are going to utilize the Identity field and add value to get next barcode numbers / employeeID as in...

Below is sample data. As I stated the Library and Food Numbers were originally being manually tracked, but they are just an auto increment by 1 when a...

Gail,

I'm not sure that would work either. The employee number is a 7 digit number and 1 barcode is only 4 digits and the other is 12 digits....

Gail, thanks, I was going to do some testing on controlling it myself. Unfortunately, there is no was to use the Identity field to calculate off of. ...