Hi All,
Blow code works and updates the Parts table with the value from the current record in the Repairs table.
dal.Table("Parts").Param("Partno")= Values("Item1")
dal.Table("Parts").Value("Qty")= Values("Item1Q")
dal.Table("Parts").Update()
I would like to subtract the Item1Q from the Qty value and update this new Qty value to the Parts table.
Is there anubody that can help or point me into the right direction.
I tried the following without success
dal.Table("Parts").Value("Qty")= dal.Table("Parts").Value("Qty") - Values("Item1Q")
dal.Table("Parts").Value("Qty")= dal.Table("Parts").Param("Qty") - Values("Item1Q")
Thank you