--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:

> At 12:06 PM 5/11/2003 +0000, you wrote:
> >I have a problem when using a master-detail and the detail is a
> >dbgrid. When a new record is posted in the dbgrid the row

disappears

> >and a refresh won't cure it. Doing a next and previous will get

the

> >record back in the grid again. I have made some changes to

KeyLinks

> >in the TIBOTable but im not sure im doing it right. If I

understand

> >it right its only the PK thats suppose to be there.
>
> It's usually the PK. The requirement is that it consists of

enough columns

> to identify each row uniquely **in the database table**.
>
> > Nothing meantion
> >if the PK has several fields so I guessed and put this into the
> >KeyFields meaning all 3 fields are in the PK.
>
> You shouldn't touch KeyFields. IBO builds it from metadata and,

if it

> can't do it, it reads KeyLinks.
>
>
> >Tablename.Field1
> >Tablename.Field2
> >Tablename.Field3
>
> If this is the primary key of the detail table then it should be

in the

> KeyLinks property, just as you have it here (each column on its

own

> line). KeyLinks is a stringlist.
>
> Helen

Hi Helen

Sorry I wrote KeyFields but I meant KeyLinks. So what you are saying
that I have done it right in KeyLinks then, but why does the lines
disappears after Post and then reappears when you do a Next /
Previous ?
I didnt start to fiddle with KeyLinks until after I got this
problem. I know there isnt any fault in the buildup of the
database/PK because the same config works in BDE/Paradox.

Peter