At 11:03 AM 03-09-01 +0000, I wrote:

> > 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?

Mike Hickman wrote:

>MH>In the new record the user enters Information into each field .
>Some information is retrieved from another dataset, in this case from
>the Chart table. All fields may contain data.

OK, so are you saying that the main dataset is retrieving information from the lookup dataset, other than the text associated with the lookup key?

Are you saying that you have more than one keylinks pair defined between the lookup dataset and the main dataset? (This MATTERS.)

Helen


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