>...snip
>
>I really appreciate all of your help....Views and table buffering are finally getting a little clearer to me.
>
>There is still one situation I am still struggling with.
>
>I have a parent, child, grandchild relationship that consists of a DSC, SKU, and a SRL file. The DSC file is the Description file ie Schwinn Bicycle, There can be many skus per description ie a Red 26" Schwinn Bicycle and a Red 25" Bicycle. For each SkU there can be many Serial# records.
>
>I have a page frame with 3 pages one for each file. I wanted them to be able to add skus on the 2nd page for the dsc record and then scroll through the sku records and add serial#'s on the third page for each of the skus all without doing a tableupdate() so they still have the ability to hit a main cancel button that would revert all of this.
>
>But if they move the record pointer on the 2nd page I then would need to do a requery on the srl view so that when they go to the 3rd page the appropriate serial#'s show.
>
>I think this is where my hang up is.....
>
>Also if I change the Category of the dsc file (on the first page), I need to go through all of the srl records for all of the sku records that match this dsc file and change the category. The only way I can think to do this is to scan the sku view and then requery the srl view accordingly.
>
>I hope there is a solution to this but maybe there isn't....Sorry for the long post but I hope its clear what it is I am trying to accomplish.
>
>Thanks so much,
>
>Paul
Yes it is. I have the same type of situation where I have a 3 tab page frame for setting security options [application level, table level and field level]. If there is an associated table with an application level of security, the 2nd page is enabled. If there are field level security options for a table option, the 3rd page is enabled. All of these sources for the respective grids have parameterized views as their source.
There is no way around issuing a Tableupdate() before a Requery() of these views without generating an uncommitted changes error if changes or additions were made.
Mark McCasland
Midlothian, TX USA