Table relationship question
I am making a simple inventory management file and I used portal to create the transaction items for a particular product (product code and lot number).
So the product code and lot number are the keys between the master product table and the transaction table.
My problem is that if I want to correct a wrong Lot Number of a existing product in the master product table, the transaction table will not change accordingly and the transaction record with wrong Lot Number would still exist and it would affect the calculation of product balance.
Any way to make the transactions table Lot Number update if the Lot Number of the master product table is changed?