>It took some effort to solve the problem I had yesterday, but it seems to have created a new problem. When I call requery('military') after an update or when skipping a record in the master table (master 1:1 military)I now get the error "base tables on the view have changed, unable to load view properties" The base tables have NOT changed scince the Upsizing Wizard sent them to Oracle. If I make a modifation and save the three affected views the calling form will work fine, once. When I re-run the form, the error happens again.
>I need to do the requery() calls in order to enforce the filter on the three(actauly 5, but two work fine) views so they and thier children will show on the second page of a pageframe.
>Any ideas how to fix this?
Does you view use SELECT *?
If so, try Select field1, field2 ... instead.
Erik Moore
Clientelligence