This does not sound correct.

I would love to have a look at a sample app that demonstrates this problem.

Jason Wharton

> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of Tom
> Sent: Tuesday, November 07, 2006 6:06 AM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] View and Table direct update?
>
>
> Well, the question is:
>
> Is it normal that when inserting a new record in a view, where one
> of the values you add is a key used in the view, that the fields in
> the grid are not refreshed directly but only after moving
> back/forward in the grid?
>
> eg assume
>
> Table X
> ID Description
>
> Table Y
> ID X_ID Fee:
>
> Table Z:
> ID Y_ID
>
> View A:
> select Y.ID, Y.X_ID, X.Description, Y.Fee
> from Y
> left join X on Y.X_ID = X.ID
>
> View B:
> select Z.ID, Z.Y_ID, A.Description, A.Fee
> from Z
> left join A on Z.Y_ID=A.ID
>
> In the grid (showing contents of the view), you insert a new record
> and you fill in a value for Y_ID. When you post shouldn't the grid
> show the values of A.Description and A.Fee ?
>
> In my case these values stay empty until I move forward/backward in
> the grid.
>
> Thanks