The created fields are standalone available in a grid but linking two tables seems not to be possible.

The following message appears, Cannot access index field '__RowID'

Hope anyone has suggestions what could cause this.

Mike,

The database tables, do they have a Primary Key ?
Also, what values are you assigning to TEDBTable.MasterFields and TEDBTable.IndexFieldNames after creating the components?
Please check that out...

--
Fernando Dias
[Team Elevate]

Hi Fernando,

Table1 is filled with orders and table2 has rows with order lines.

Table1
=====
OrderID (is primary key)
CustomerID
etc.

Table2
=====
OrderID
LineNumber

Because I can't create a primary key for for table table 2 I have created an normal index on fieldname OrderID.

The following code is used for the master source link.

 Table2.IndexName := '';
 Table2.MasterSource := DataSource1;
 Table2.MasterFields := 'OrderID';

Hi Fernando,

Writing it down helped

An incorrect indexname was used.

Thanks for your help!