Subject [IBO] Re: TIB_LookupCombo: no selection possible
Author Svein Erling Tysvær
Hi Mirco,

>SQL.Strings = (
> 'SELECT *'
> 'FROM ASSAY, TEST LEFT OUTER JOIN SAMPLETYPE'
> 'ON SAMPLETYPE.SAMPLETYPEID=TEST.SAMPLETYPEID'
> 'WHERE ASSAY.ASSAYID=TEST.ASSAYID')
...
>Nothing unusual here as well.

yes, there is! You're mixing SQL 89 and SQL 92 (I think), without
specifying JoinLinks. Change to

SQL.Strings = (
'SELECT *'
'FROM ASSAY'
'JOIN TEST ON'
'ASSAY.ASSAYID=TEST.ASSAYID'
'LEFT OUTER JOIN SAMPLETYPE'
'ON SAMPLETYPE.SAMPLETYPEID=TEST.SAMPLETYPEID)'

Don't know if this has anything to do with your problem though...

Set