>I am thinking I can use a new format for creating lot codes and store the old lot codes in the table to provide traceability back through the historical data...

I have done that successfully in the (long-distant) past.

Kevin