I'm using Interbase. I don't use compound indexes but only in a
handful of tables. The table I'm using doesn't have compound
indexes. I do however have joins in nearly all of my queries. But
shouldn't it be able to get the primary tables primary key for the
keylink? Give me the rule of how to manually create the KeyLinks.

Thanks again you have been a ton of help.

Matt

--- In IBObjects@yahoogroups.com, "Artur Anjos" <artur@a...> wrote:
> Matt:
>
> IBO does it's best to do it, but sometimes (specially with compose
keys)
> it's not easy to it to get the rigth KeyLinks. If your query has a
primary
> key, and you don't have joins, the auto feature works fine.
>
> Work with IBO Monitor. That way you will notice this problems in a
second
> (you will see what IBO is doing in the background).
>
> You are telling us that you fix this just by putting tablename
before the
> fields. Are you using Interbase or Firebird? Have a feeling that
you are
> using Interbase and using some kind of a ambigous query. This will
work with
> Interbase, but can give you erraneous results (Firebird will return
you an
> error, making it more easy to debug).
>
> Artur
>
> ----- Original Message -----
> From: "manielsen2002" <mnielsen@c...>
> To: <IBObjects@yahoogroups.com>
> Sent: Wednesday, May 28, 2003 1:03 AM
> Subject: [IBO] Re: Refresh Single Record
>
>
> > Thank you. That worked like a charm even with cached updates.
Why
> > is the system not creating the KeyLinks correctly. Is there a
way I
> > can correct this? Looks like it just needs to put the table name
> > before the field name in the key links.
> >