I created the local view "lvProduction" based on two other local views..."lvProduction_a" and "lvProduction_b".

Local view "lvProduction" is diplayed using a grid on two different screens (forms). The Production screen (seperate executable) and the Weigh screen (seperate executable).

When an operator completes the fabrication of a product that product is entered to the Production table immediately. The product then moves to the Weigh station to be weighed.

I add a record to the production table correctly through "lvProduction" by sending SQL Updates within the Production screen. I also get the weight to the appropriate product/record again using the same SQL updates from "lvProduction" from the Weigh screen

My problem is that if I try to edit that particular product/record again from within the Production screen VFP crashes because the TABLEUPDATE() failed and I receive an "Update conflict" error message?

Does anyone know why this is going on?

Thanks in advance!