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.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05