Subject Re: [IBO] Master-detail with TIBOQuery
Author mitch_landor
At 10:28 AM 8/11/2005 -0300, you wrote:
>>Hi,
>>
>>Is there any hide property in TIBOQuery to set master-detail? With
>>TIB_Query I use masterSource + masterLinks but I didn't find these
>>properties in TIBOQuery.

It is just the same as TQuery in this respect. Use the Datasource property
of the detail set to point to the TDatasource of the master set. Provided
the foreign key of the detail table matches the primary key of the master
set by name and type, that is all you need to do.

>Should I use "where" clause to do this?

You will have to use a where clause only if the names of the detail's FK
and the master's PK do not match.

Helen

=======

I need to use the "where" clause because my Fkey/Mkey field names do
not match. In this case how do I get the Fkey field in the detail
table to fill in automatically when I add a detail row?

It was all working splendidly and I changed something (can't remember
what) and now detail inserts don't work properly.

Thanks
Mitch