>I have a merchandise maintenance form (A) with a field where the user can
>enter the warehouse code which is validated against the warehouse table.
>I have another maintenance form (B) that is for warehouses.
>Both forms are set as private datasession.
>Now: The user goes in edition in form (A). He just put the cursor in the
>field for the warehouse code where "ABC" is already entered (He is in
>modification). Now he goes in the menu and open form (B), search for the
>warehouse "ABC" and modify the description or whatever field. He saves it.
>Behind the scene, in form (B), the save does a BEGIN TRANSACTION, a
>=TABLEUPDATE(2,.T.) and END TRANSACTION (this is part of the framework, even
>if the transaction is not necessary here).
>Now, back in form (A), he saves merchandise table. and hop error 1585!
I don't know why this is happening at this point. I'll make some assumptions, though.
1) You don't mention if you are checking the return value from TABLEUPDATE() -- is it returning .T. or .F.?
2) When you say "saves merchandise table", do you mean that you're trying to do the same sort of BEGIN TRANSACTION/TABLEUPDATE()/END TRANSACTION routine? Do you explicitly select the merchandise table before doing the update?