Yes, John, thanks - that's what I've always heard here and I have followed that advice...AND I'm having this strange thing happening...and am at my wits end.

Maybe I can present my problem in a clearer way than I did before...anyway here goes:

I have a table, Agencies.DBF, that has a primary key, CODE, and a description field, AGENCY (I know, I know, not much of a naming convention); there are other fields in the table.

The table is updated via a view, ModifyAgencies, in a modal form, MaintainAgencies - which uses a private data session. MaintainAgencies can only be called from the menu from the "main" form.

Data from Agencies.DBF is used in another form that is called from the main form, Reservation. It's used as the source for a combo for the user to choose an agency. This form is also modal, and uses a private data session.

When I run MaintainAgencies and add an agency, all looks well...if I then go to the Reservation form, the new agency is not there.

If however, if I run MaintainAgencies and add an agency and run a third form (that inputs the agency for which to generate a report), the new agency shows up...this form uses the Default data session.

>Auggh!!
My feelings, exactly.

Regards, J


>Jill, run screaming from having both open in the same DE. Use only the view. Let VFP handle the base table update. Do not explicitly open it in the DE.
>
>
>>I'm STILL having trouble with this and keep going back to your message.
>>
>>>I ran into something similar a while back that might be related to what you're seeing. Essentially I ended up having to call the tableupdate function twice. In my case I had both the table and the view in the DBC and for some reason this was what was needed to make sure the update made it all the way to where it was needed.
>>
>>You mean "both the table and the view in the " DE of the form? and you're updating via the view? I'm using optimistic buffering for the view...what do you set for the table?
>>
>>And you call the TableUpdate for the View twice? or once for the table and once for the view - in what order?
>>
>>TIA, J