Base: table widget in form shows combobox. How to make so? [closed]

asked 2014-06-14 23:07:29 +0200

Alexander Varnin gravatar image

updated 2015-08-27 20:51:50 +0200

Alex Kemp gravatar image

Hello. I am learning to make DBs with Base, and i took an example from LO wiki : https://wiki.documentfoundation.org/i...

Here, when I open Reader_Admission form, i can add readers to table control widget. There is Gender field in the table, where I can select value through combobox - male or female. However, data source for the form is a query called Reader_Input_Filter. This query contains only Gender_ID field. This field is linked with Gender. So it is somewhere set, that this table could show the field, using values from other table.

I wanted to implement the same. however, it doesn't work so. In my table it doesn't substitute ID fields in table with combobox containing values from other table. So I can't select variant of value from other table, I could only enter the ID manually. Links in relations editor is set. I can't post my test DB because my rating is not enough (just registered). The only difference I see, is that Gender table in example has TINYINT type of primary key, while my example has INTEGER. I wonder, if it could be the reason?

LO version: 4.2.3.3 OS version: Ubuntu 14.04 64 bit

edit retag flag offensive reopen merge delete

Closed for the following reason duplicate question by Alexander Varnin
close date 2014-06-15 02:37:09.607364