How to display text in combo box?
Posted: Sun Oct 30, 2022 3:38 pm
Hi, I am new to open office, and I have one naive question:
1) I have a table called record, which links to another table called importance with a foreign key importanceId.
2) Using the form wizard, I am able to create a form for record, with a combo box entry for importanceId, and with the content of the importance table displayed in the drop down of the combo box, such as "Not Categorized".
But I have two problems:
1) The text box of the combo box displays the importanceId 0 rather than the text "Not Categorized".
2) If I choose any other text in the dropdown, the text box of the combo box always becomes 0.
I am sure that this rudimental question is answered already. If so, please give me a pointer, because I am unable to find an answer to this.
Regards,
CP
1) I have a table called record, which links to another table called importance with a foreign key importanceId.
2) Using the form wizard, I am able to create a form for record, with a combo box entry for importanceId, and with the content of the importance table displayed in the drop down of the combo box, such as "Not Categorized".
But I have two problems:
1) The text box of the combo box displays the importanceId 0 rather than the text "Not Categorized".
2) If I choose any other text in the dropdown, the text box of the combo box always becomes 0.
I am sure that this rudimental question is answered already. If so, please give me a pointer, because I am unable to find an answer to this.
Regards,
CP