I've made a copy of vdvInventoryDistribution and I'm trying to add a column to it called say, to be descriptive, OldestTranDateForThisLotNo.
Suppose every record has a LotNo. Most LotNos appear in multiple records. I want to add a column that will indicate…