Subject Re: [IBO] Master-Datail problem
Author Helen Borrie
At 11:55 AM 12-12-01 +0100, you wrote:
>Hello, I'm newbie with IBO and IB.
>
>I'm traying to make master-datail relationship with to tables and I MUST use
>TIBOTABLEs.

Then master-detail is very simple to implement - it is exactly like the VCL TTable - read the Delphi help for more detailed instructions. Don't expect wonderful performance using tables, though.


>If I use IBX components it works (tables infact dont't have any "real"
>realation between them or foreign key). They are related this way:
>USUARIOS.IDDEPAR=DEPAR.ID (detail-master).

The important things to do are:

1. Make sure you have correct KeyLinks for both the master and the detail sets.
2. Set the MasterSource property of the detail set to the TDatasource you have connected to the master set.
3. Set the MasterFields property to the column (or columns) that forms the links, having the detail's column on the left, e.g. IDDEPAR=ID

That should do it.

Helen