As a quick and dirty solution, which comes to mind: did you try to set relation to (delete relation) in Add method and restore it back in Save/Revert?
>I have a grid that shows raw materials records with these fileds:
>
>vend_no, qty, descrip, price
>
>This table is related to the vendor table via the vend_no field.
>
>grid.Column1 uses text1 to display vendor.vend_name during display mode but, switches to a custom class textbox to input and validate the vend_no when adding a new record (or editing an existing record).
>
>The problem is that when I do "append blank", then vendo_no field for the new record is blank, and therefore the vendor table goes to eof() since there is no match on a blank vend_no. The problem with that is that VFP then switches my custom class to read-only!
>
>I had to create a record in the vendor table with an empty vend_no to prevent going to eof(), then it worked. But I do should not have to go to this measure to make this work.
If it's not broken, fix it until it is.
My Blog