Chuck,
Sorry but I still couldn't get why tablerevert() wouldn't work. Just create a wizard one-to-many test form. Wizard forms use buffering and tablerevert().
In a buffered table unless it's row buffered there is nothing updating data till you call tableupdate().
If for a moment I could think it wouldn't work then a view that's not sending updates or a cursor might be another option.
Transaction is another alternative (wizard QBE form uses this technique).
If It wouldn't do too I would use old fox2x style memvar scattering-gathering rather than inserting and deleting.
Cetin
>I have
SELECT person in the form Init (for in order to make the grid have only related records), so I am assuming that's why this revert command won't work. The form has two "display" fields from PERSON and the rest is from AUTH table (both fields and grid). Either way, I tested it and does not work.
>
>Chuck
>
>>>I am using
INSERT INTO auth (id) VALUES (person.id) for the 'Add' button, so, I can not use
=TableRevert(.T.), but have to use
DELETE (but not PACK) for the 'Esc' button?
>>
>>Chuck,
>>Why can't you use tablerevert() ? You could as long as 'auth' is buffered.
>>Cetin