Dear King, you can do so to create the trigger of database, but there is one issue, the UI(user intereface) has it own validation in RMS. mean whenever you create new item the UI of RMS> Item Screen give you warning that you must enter the item lookup code. you can do so by entering anything may be one numerical character but the system generate the code base on the below trigger as item lookupcode : here is the code: CREATE TRIGGER CreateLoookupCode ON Item FOR INSERT AS
UPDATE Item SET ItemLookupcode=(Select Max(B.ItemLookupcode)+1 from item As B) FROM Item INNER JOIN Inserted ON Item.ID= Inserted.ID
Before try make sure that you understand the code. If solution is good please rate me.
"knightsbridge" wrote: