At 08:40 AM 03-09-01 +0000, you wrote:

>Hi Helen,
>Hoping you would answer. Sorry if it looked confusing. Details below.
>
>Detail table which I want to insert new records into is Bankdetails.
>This is referenced by the following query
>
>
>Query name sqlbook
>sqlbook.sql:='SELECT BANKCODE , DTE , REF , ACCOUNTAMOUNT ,
>BANKAMOUNT , BANKSTREF
> , BOOKREF , CHART , CHQNO , DETAILS ,
>RECEIPTNO , COSTCROSSREF,LINENO
>FROM BANKDETAILS
>Where Bankcode=:Bankcode
>Order By Lineno'
>
>
>This table has an index IDXBankDetails4;Ascending Sort.
>
>Datasource named dsbook property dataset is set to sqlbook
>
>sqlchart query is as follows :
>SELECT ACCOUNT , CHARTDESC , CHARTGROUP , CHARTSUB
>FROM CHART
>
>The chart table has an indexed field IDXCHART which is unique.
>sqlbook.chart and sqlchart.account use the domain ChartAccount.
>
>Sqlchart has the following properties :
>Keylinks......chart.account= BankDetails.chart
>Keysource .... dsbook

The KeyLinks between the lookup table should be the field in the lookup table that determines the uniqueness of the lookup rows. Normally this would be the primary key of the lookup table. I can't see the relevance of the indexed field IDXCHART here, since it's not in the dataset.

Is Account in the table chart unique? (it needs to be, or the logic won't work).

Why do you have so many fields in the lookup dataset? I assume you only want the field Account from chart to be written to Chart in the bankDetails table?

>The form has a grid ... Grid1. Its datasource property is dsBook.
>
>To Summarize. The name of the query in the Grid is sqlBook.
>Name of the datasource linking the grid to the query is dsBook
>The name of the sql for displaying in the LookupCombo is sqlChart
>
>The intruiging thing is that the lookupcombo acts as expected if
>placed on the form outside of the grid. My problem occurs when I Cut
>and Paste to the Grid.
>Then the LookupCombo is not visible and entering the Chart column of
>sqlbook does not activate the LookUpCombo.

Do you realise that, when it's embedded in a grid, the lookupcombo is only activated in dssEdit or dssInsert? Have you tried putting the main dataset into Update mode to test this?

Cheers,
Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________