>>>I have created View with parent and child tables in it.
>>>
>>>When I insert new record into view and then do TableUpdate() it's ok except that some fields are blank. Those fields are from child table, unless I do requery() they are blank. How can show them without doing requery?
>>
>>What you have in these fields?
>>What ARE these fields?
>>Did you update them before TABLEUPDATE()?
>
>Simple view with parent and child fields.
>Problem is when I insert some new record child fields are blank.
OK, when you insert new record did you REPLACE these fields or set values for them in INSERT command?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.