COMBOBOX bad behavior
Posted: Fri Sep 17, 2010 4:52 pm
When using COMBOBOX linked to a two tables, as a conventional database design mode, there is a bad bahavior, as explained:
...
ITEMSOURCE DIAGP->NAMES
VALUESOURCE DIAGP->CODE
...
IF in the main table the destination field ALWAYS HAVE A VALUE, everything works well.
But if we can have a "null" value in the destination field, for instance user did not made a choice, after save and returning to this register, COMBOBOX SHOWS THE LAST REGISTER of the source table, in this case DIAGP. It should shows empty, of course.
I don´t know if I was clear. Unfortunably, I tried but was not abel to undesrtand and fix the source code for COMBOBOX.
Tks for any help.
...
ITEMSOURCE DIAGP->NAMES
VALUESOURCE DIAGP->CODE
...
IF in the main table the destination field ALWAYS HAVE A VALUE, everything works well.
But if we can have a "null" value in the destination field, for instance user did not made a choice, after save and returning to this register, COMBOBOX SHOWS THE LAST REGISTER of the source table, in this case DIAGP. It should shows empty, of course.
I don´t know if I was clear. Unfortunably, I tried but was not abel to undesrtand and fix the source code for COMBOBOX.
Tks for any help.