Connecting(linking) two table

boloyoung · Post by **boloyoung** » Mon 29 Jan 2007 07:15

Hello

How can I joint two tables using ODAC TOraTable ?
I want to make similar thing as in case BDE Masterdata/Mastefields.
When I try use Masterdata/Mastefields I don`t see ellipsis button next to the MasterFields and I Can not invoke the Field Link Designer.

Please help

Regards

Plash · Post by **Plash** » Tue 30 Jan 2007 12:26

The ellipsis button should be shown for the MasterFields property of TOraTable. We cannot reproduce the problem. Please specify full ODAC version (with build number) and Delphi version you use.

boloyoung · Post by **boloyoung** » Tue 30 Jan 2007 16:32

Borland C++ Builder 6 Enterprise Suit (Build10.157)
ODAC 5.80.0.39
Ora Tools Add in 2.60

Plash · Post by **Plash** » Thu 01 Feb 2007 09:27

Currently ODAC has no special editor for the MasterFields property in C++ Builder. You can define values for the MasterFields and the KeyFields properties of the TOraTable component in object inspector by typing field names manually.
We'll add the editor for the MasterFileds property in the next build of ODAC.

boloyoung · Post by **boloyoung** » Thu 01 Feb 2007 16:35

Thx plash for help.
However, manual defining of values does not work.
If you can please, write down how can I make it? Regards

Plash · Post by **Plash** » Fri 02 Feb 2007 08:38

You should set the MasterSource property of the detail table to a TDataSource component that is connected to the master table. Then assign master table field name(s) to the MasterFileds property of the detail table. Assign detail table corresponding field name(s) to the KeyFileds property of the detail table.