I have form that has these fields [SaleDate], [BarcodeNO], [ProdName], [ProductPrice],[ProducMaxNO], [ProductStock] and [ProductEndNO].
[ProductStock] is look up table and it has three choices [Onshelf], [MaxNumber], [BackStock] which is 1, 2 and 3. the default is Onshelf what I like to do is...