In c# .NET I need to combine the following values to create a unique inventory control number for a product. The method must:
Get 2 digit Plant number from Table “PLANTMASTER” WHERE “currentLocation” = 1
Get 2 digit year from system DATE/Time
Get Reader Number (a value of 1 digit located in Table “READERNUMBER” WHERE “currenReader = 1)
Get last ticket number (5 digits) from table and increment by one
Combine these values into value called newTicket and display it in the appropriate text box on a form.
I thought this would be easy enough but I am struggling wth it.