Hi John
>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?
Are you re-querying the view after the insert?
If you have default values being inserted in the tables (like a primary key), the view will not have that value and so when you try and update it, VFP sees a conflict because the table has a value that is not in the view.
Use the REQUERY( '[viewname]' ) function to refresh the view after an insert to ensure that the view is properly synchronized with the table
----
Regards
Andy Kramek