I’m using LibreOffice 5, with Windows 8.1.
I’m having a problem creating a form with LibreOffice’s Database. I want my ComboBox to have the same capibility as a ListBox.
Specifically, I want to create a selection list from a name field from another table and upon selection of this name field, return the corresponding primary key and place it into an ID-pointer of a record field that i’m currently populating in a different table.
I realize i can do this with a ListBox. But, I want to do this with a ComboBox because the ComboBox works better. it lets me type part of the String and have the list jump to the nearest record without needings to scroll through a huge list of elements as with the ListBox.
So I’m wondering. Is it possible to emulate the Translation capiblity of the ListBox in a Combobox by writing a macro? Another angle, is it possible to make the ListBox act like a textbox/combobox by setting a control property. (Note, I already know about dropdown property. What I want is it to behave llike a TextBox and allow me to look up the name field by typing the string and then translate it into the id field.)