I do have two tables in an Interbase 6 database accessed by
IB-Objects:

Players
P_Key: Integer;
Name: String;
CaptainKey: Integer;

Captains
P_Key: Integer;
Name: String;

I use a TwwDbGrid in which I need two columns:
Players.Name
Captains.Name

There are three necessities:
1. The Players.Name must be editable.
2. The Captains.Name must be selectable from a LookUpCombo
3. The grid must be indexed on either column by means of the
TitleButtonClick-method.

I tried a join-TIBOquery, but then the Captains.Name isn't
editable.

I tried to use a TIBOquery with a lookupfield for the
Captains.Name, but then I can't index on the Captains.Name using
OrderingItems.

I tried a ClietDataSet - DataSetProvider combination connected to
the same query with the lookupfield, but then the Captains.Name
is not editable.

How do I solve this problem?

tia,



_________________________

Gerard J.M. Houtenbos
DoubleWood Software