I'm tring to move from msAccess to OpenOffice. I'm not expert at all.
I have a working form in msAccess, but I don't understand how to implement it on OO.
The form is used to select a customer by typing the phone number or the name. When the user starts typing name (eg: "rt") or phone number (eg: 342) the basic script connected to the event "modified" writes a SQL string that is used to change the "rowSource" propery of the list box, so that the list box content is narrowed by the updated SQL query.
Now I have two questions:
- Is it possibile to display more than one column in a OO listbox? So far I just succeded in showing only one column
- Is it possibile to change the data source of the listbox, writing a property with a SQL string?
THanks a lot.
Salvatore