ComboBox Column

Creating and using forms

ComboBox Column

Postby uliggett » Tue Dec 04, 2007 5:33 pm

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?
uliggett
 
Posts: 3
Joined: Tue Dec 04, 2007 5:11 pm

Re: ComboBox Column

Postby uliggett » Wed Dec 05, 2007 3:37 pm

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
uliggett
 
Posts: 3
Joined: Tue Dec 04, 2007 5:11 pm


Return to Forms

Who is online

Users browsing this forum: No registered users and 2 guests