[Hk-classes-discuss] Knoda Combo Box oddity?

[bluest...@iinet.net.au]

Here's what I am doing.  I have a music database with a column that lists composers names.  I have added a combo box to a form with this column as it's datasource.  The problem is to do with the listdatasource. What I want, is for the pull down list to display a list of all the composers previously entered into that database column.  Knoda doesn't let you have the listdatasource the same as the main datasource, so I created a separate query basically as follows...

select distinct composers
from musicdatabase
order by  composer;

and made this query the listdatasource.   This works up to a point.  The pulldown list uis populated correctly and I can select a composer.  I can also type in the combo box and it preselects the first match to what I type.


What DOESN'T work is when I have a new composer, never entered in that column before.  I type the new name into the combo box, but when I save the record, knoda saves the nearest choice from the list, NOT what I had typed.

Is this a bug, or am I doing something wrong? 

------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Hk-classes-discuss mailing list
Hk-classes-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss