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
--- In IBObjects@yahoogroups.com, "Jason Wharton" <supportlist@...>
wrote:

>
> I read this twice and I didn't get a clear understanding of the

problem.

> Could be that it's just Monday morning, but if you would please,

expand on

> this a bit.
>
> Thanks,
> Jason
>
> > -----Original Message-----
> > From: IBObjects@yahoogroups.com

[mailto:IBObjects@yahoogroups.com]On

> > Behalf Of Tom
> > Sent: Sunday, November 05, 2006 3:34 AM
> > To: IBObjects@yahoogroups.com
> > Subject: [IBO] View and Table direct update?
> >
> >
> > Hi,
> >
> > I've a TIBOTable which is feeded by a view (v), the view itself

is a

> > join over a database-table (a) and another view (b).
> >
> > This table is connected with a mastersouce table.
> >
> > A grid is connected to this detailtable through a datasource. The
> > grid displays two values (from b).
> >
> > When I add a line in a grid (connected to a datasource to the
> > detailtable). I can provide a value to a field, but when I press
> > enter, the grid does not shows the corresponding value of the

second

> > field. When I move back and forward in the master grid, the

detail

> > grid shows both values correctly. So I guess the grid or table
> > doesn't refresh itself immediatelly after the insert...
> >
> > Is this normal behavior? Can I do something about it?
> >
> > Thanks
>