I have a Table control on a form that is linked to a MySQL SALE table. One of the fields in this SALE table is a PRODUCT_ID. However, instead of showing this ID number, I want to show a combobox of the product NAME.
Essentially I'd like to make one of the columns of the table a ComboBoxColumn the same as .NET provides with DataGridView. Is this possible with OOo base?
ComboBox Column
Re: ComboBox Column
I figured it out.
You right click on the column and choose Replace With | List Box. Under Data enter the following
Data field................ PRODUCT_ID
Type of list contents... Sql
List content............. SELECT NAME, PRODUCT_ID FROM database.PRODUCT
Bound field.............. 1
You right click on the column and choose Replace With | List Box. Under Data enter the following
Data field................ PRODUCT_ID
Type of list contents... Sql
List content............. SELECT NAME, PRODUCT_ID FROM database.PRODUCT
Bound field.............. 1