Hi Mark,

>Couldn't this be done with a SET RELATION TO and/or SET SKIP TO [with the table buffering]? IMO, I would have the user commit or revert changes when the Division or Company is changed.

I suppose SET RELATION and SET SKIP could be used.....never really tried it in this context.

>How would you do this if the backend was SQL Server or Oracle? Even when I use VFP as the backend, I have started asking myself this question and design that way [just in case the project eventually ends up as C/S].

Well, that what was why I prefaced this with "this is for native tables". I dunno, but I probably would have to granulate the saves/reverts.