Thanks again Geoff. This has helped a lot. I have tried to make a cut-down
version of my form. But in tidying it up and reading your message carefully
I have got things working Nearly!!
I put ib_lookuplists inparallel with the combos so I could see what was
happening there. And I see
Then I put a grid onto the Main record and as I select from the combos I can
see that the entries are appearing in the grid Hurrah!
But then when I close the form I get the message "Record was not located to
update " and all is lost.
Am I missing something in closing (I commit the transaction and close all
the queries. or is it is the original SQl select * from tempbook for
update ..does it need a where clause ?(There is only one record there !

----- Original Message -----
From: "Geoff Worboys" <geoff@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, April 30, 2001 2:37 PM
Subject: Re: [IBO] LookupCombo


> > Yes I dont have BDE installed I do use all IB_Objects controls.
> > It is just getting my mind around various controls and their
> > intended way of operation I find difficult.
>
> The LookupCombo can be quite confusing since the control itself does
> not link to the main dataset - for which you want to lookup a value.
> Instead it is the lookup dataset that links to the main dataset - via
> the KeySource and KeyLinks entries. All the LookupCombo does is drive
> the lookup dataset.
>
>
> > The combo is connected to the lookup table and is
> > showing the list of town to select...what happens next ?
>
> When you select a record, the lookup dataset uses its KeySource
> (linking to the main dataset) to assign the fields specified. So if
> you have:
>
> LookupDataset.KeyLinks =
> Lookup_Table_Field=Main_Table_Field
>
> When you select a record using the lookupcombo, the lookup dataset
> looks at the above entry and assigns the value the Lookup_Table_Field
> (from the lookup dataset) to Main_Table_Field (in the dataset attached
> via the KeySource).
>
>
> > (When the user presses the 'check' button the data is
> > transferred from the lookup to the main record...but
> > this is no different from using non data-aware components).
>
> I dont understand what you are saying here. There is no "check"
> button involved, simple selected a record using the lookupcombo and
> the lookup dataset should assign the fields specified.
>
>
> Is any of this helping? Perhaps if you post a cut down version of the
> dfm showing what you are using I can be more specific to your
> situation.
>
> Geoff Worboys
> Telesis Computing
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>