Re: Re: LookupField have KeyFields with more than one field

Posted by Sidney on October 20, 2000 at 14:42:06:

In Reply to: Re: LookupField have KeyFields with more than one field posted by Martin Jackson on October 18, 2000 at 14:42:26:

I want to show a list of values from one table and store the result in another. For this I created a LookupField with two fields in KeyFields and LookupKeyFields. This is wrong?

: Unfortunately, the DBLookupCombobox does not seem to like multiple key lookup values. What is it you are trying to provide for the user ? For example do you want to show a list of values from one table and store the result in another, or do you want to retrieve a single value from another table, and display the result read-only to the user? The latter can be achieved by manually placing a dbedit on the form instead of drag-dropping the field. To list the values from another table you will need to set up another parameterised query.