Real-World Form

[littlehouse]

Hi everyone.
mysqltables
Table (autoid,item, price)
item(autoid,item)
price(autoid,price)
I want to construct a form for browsing and adding data to table.
I want to build this form in a smarty way so that when a user want to add a record the form should present in a combo-box not the real value of the Table fields (1,2,3,4,5 for example) but the masked value: flower, tree, grass...and the same for the price, but will store in Table the autoid of the item and the autoid of the price.
Browsing the record should also appear the masked values.
Is there an example of how to do this.
Is just the way the phpmyadmin extension work.
Thanks

[GraemeWi]

I did something similar for another user a couple of weeks ago:

http://www.graemewi.orcon.net.nz/OOo/products.html

The only thing that would need to be changed is the properties of the columns in the table control, set them to enabled and change the read only to 'no'.

Ignore the bit about the filters as well as the user was after a form to update just the price (not adding more fields etc)

Cheers,

G

[littlehouse]

Thanks very much

[littlehouse]

Ops.
Everything work but the update process is not correct. When I look at the value stored with phpmyadmin I see the masked values (grass, flowers,...) and not the autoid values (1,2,3,4,5...) so it doesn't store the correct values.

In my version of openoffice (RC5 Italian) the data properties of the control doesn't have the "Bound field" row: it has only Data Field, Type of list contents, List Contents and The Zero-Value control.

[Guest]

Solved.
I used the wrong widget (combo instead the list box)
Whit list box everything is ok