Combo box in Base Forms

[gemeye]

I’m familiar with creating a combo box in an Access database for both a table and a form. I have no clue how to proceed in Base. I start with creating the combo box control in the form design screen after that, I have no clue. Tried all kinds of false starts. Someone please help.

I should comment that the LibreOffice documentation is absolutely worthless. I have all the basics and that’s all it presents. Anything beyond that such as the couple of questions I’ve already posted after only a few hours trying to work with this thing there are no answers. I’ve trawled the internet over and over no luck.
There is no relevant documentation.
Who are the people who know this stuff, the designers and coders, and how does one reach them?

[tohuwawohu]

I agree that the Base documentation is very sparse. I usually skip the LO docs and search for OpenOffice Base tutorials and infos. Usually, the solutions that work for OOo work for LO, too.

[ManoEngel]

You may want to have a look at this page: https://wiki.documentfoundation.org/Documentation/Publications

[DonLow]

I’m also new to Base, and frustrated with the steep learning curve. I think what I found about the combo box in a form may help you. (I was looking for something else when I did this). I opened my form in the edit mode. Along the left side of the screen there are a column of icons, one of which is combo box. I clicked on this icon, and then drew a box in my form. The box has two parts. Right clicking on these boxes brought up a dialog box that let me choose where to get the list, how to display it and so forth. I hope this helps you with what you’re trying to do.

[Q]

I have just taught myself what I think you want, Base is very similar to Access but no-one has written down how to convert access think to Base. If you want to make a combobox the same way as access try this.

after you have placed a combo box as described in the previous answer use the tools on the left and bottom of the screen. Base is like access with a design view and a user view. Have a look at this screen grab cant upload no Karma

the key point is use the form navigator to get to the properties and the rest is access like, knowing about the form navigator is a closely guarded secret.

hope this helps

Q

[prekopz]

Thank you!

[dalexdba]

The way I got listboxes to work is a little obtuse compared to access.
The control needs to be assigned to a data object in the form, but when the wizard starts, what it is really asking you for, is where you want to look for your list items. Start by selecting a table you want the data to come from, then get the fields from that table you are comparing against the form control table. These don’t have to have the same name, but the contents must be compatible.
So, if you have a form expecting the index field from a table, but that doesn’t make any sens to the user, you wish them to select a value from other fields in another table, the source for the list comes first, and the assigned column from that list is set to be the same value as you wish to insert into the underlying form table. The field offset value is which field from the table to equate.

For exampe say you have a table called projects consisting of id,projectname, sponsorID and another table called sponsor with columns id,surname.
You wish to build a form based on projects, but need to use the sponsorID from a valid sponsor.

Once you have the basic form set up and saved,

1. add a listbox control.
   The wizard starts but the first text mentions the data control.Ignore that, and read the 2nd sentence.

2. Pick the list source table or query that you want the users to make some sense of.
   In the example above, select Sponsor and click Next.

3. Click on the column you would like to see displayed from the sponsor table. Click on Surname and click Next.

4. The wizard then presents you with 2 columns. On the left, select the field from the form data eg SponsorID, and from the right column, select the linked field, eg ID.

5. Click Finish. Save and view your form.
   Job’s a good un.