Subject Re: [IBO] Two editable and indexed columns from two tables
Author Gerard J.M.Houtenbos
Does the fact that knowbody has followed this thread, mean that
it is not possible?

Gerard

On Wed, 18 Dec 2002 20:14:48 +0100, you wrote:

>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
>
>
>___________________________________________________________________________
>IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
>___________________________________________________________________________
>http://www.ibobjects.com - your IBO community resource for Tech Info papers,
>keyword-searchable FAQ, community code contributions and more !
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>

_________________________

Gerard J.M. Houtenbos
DoubleWood Software