At 12:10 PM 11/09/2004 +0200, you wrote:

>hello Helen,
>
>thank you for quick reply.
>
>This is the ANAGRAPHICS table SQL:
>
>SELECT A.ID_ANAGRAPHIC, A.PREFIX, A.UNIT, A.CALL_SIGN,
>A.OPERATOR_NAME, A.CITY, A.TX_PROVINCE,
>(SELECT SHORT_NAME FROM PROVINCES WHERE ID_PROVINCE = A.TX_PROVINCE) AS
>TX_PROV,
>A.TX_REGION, A.OWN_PROVINCE,
>(SELECT SHORT_NAME FROM PROVINCES WHERE ID_PROVINCE = A.OWN_PROVINCE) AS
>OWN_PROV,
>A.OWN_REGION, A.CLASS,
>A.OP_2_PREFIX, A.OP_2_UNIT, A.OP_2_CALL_SIGN, A.OP_2_NAME,
>A.OP_3_PREFIX, A.OP_3_UNIT, A.OP_3_CALL_SIGN, A.OP_3_NAME,
>A.CERTIFICATES, A.AMOUNT
>FROM ANAGRAPHICS A
>ORDER BY A.PREFIX, A.UNIT
>
>This is the PROVINCES table SQL:
>
>SELECT * FROM PROVINCES
>WHERE ID_PROVINCE > 0
>ORDER BY SHORT_NAME
>
>And this is the TIB_LookupCombo code taken from the dfm (I have two combos on
>the form but they do the same thing for two different province fields in the
>ANAGRAPHICS table):
>
> object TXLC: TIB_LookupCombo
> Left = 16
> Top = 168
> Width = 64
> Height = 24
> Hint =
> 'Transmission province|Select the transmission province from the ' +
> 'drop down list'
> HelpType = htKeyword
> HelpKeyword = 'Edit anagraphic: How to select the transmission
> province'
> AutoLabel.Kind = albTop
> AutoLabel.Caption = '&TX prov.'
> AutoLabel.Margin = 0
> AutoLabel.Model = ModelLabel
> AutoLabel.Options = [albBoldIfRequired]
> DataSource = AnagDM.TXProvDS
> TabOrder = 3
> TabStopAutomation = True
> ColLines = True
> DefaultRowHeight = 18
> DisplayField = 'SHORT_NAME'
> GridLinks.Strings = (
> 'SHORT_NAME'
> 'LONG_NAME')
> OnChange = TXLCChange
> OnCloseUp = TXLCChange
> ShowButton = True
> end

Please show the dfm details for the lookup dataset, esp. KeyLinks,
KeySource and KeyDescLinks.

Helen