Bug 88186 - Enhancement Request: Drop Down lists in Base tables (like in Access)
Summary: Enhancement Request: Drop Down lists in Base tables (like in Access)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected) Master
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Database-Tables
  Show dependency treegraph
Reported: 2015-01-08 00:58 UTC by Xavier
Modified: 2017-11-02 23:06 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description Xavier 2015-01-08 00:58:18 UTC
Problem description: 
Current versions don't allow Drop Down lists in Base tables, when we have relationships among several tables. Sometimes this feature is very useful, because people not always are using forms to introduce data. Many people use directly the table to introduce the data.

Steps to reproduce:
NONE. Just using the program.

Current behavior:
Base don't allow drop down lists in tables, like Access.

Expected behavior:
Let's imagine I create a drop down list in Base, in such a way I can see a list of values I've added (like for example Gender, Male, Female) without having to type those values. 
That would be great, the possibility to create drop down lists.
But also, this is very important when we have a relationship among tables. Let's imagine I want to relate the table employees with the table cars. Every car model and maker, of course, have a number. 1 - Mercedes Benz E300, 2 - BMW 5 Series, 3 Honda Civic... 
Due I have a 1 to 1 relationship in both tables (one employee could be related to a single car) of course, inside the table employees, I would be able to introduce the car that is assigned to that particular employee.
Actually I can do that, perfectly.
The problem is, that, because I cannot have Drop Down lists in Base, I have to remember the car code 1, 2, 3... etc. and introduce that code.
Let's imagine I want to assign BMW 5 Series to my employee John Doe... well then I would have to type 2... because BMW 5 Series is registered with the number 2 in the cars table.
Okay, that is complicated, becuase if I have 50 or 100 cars, I cannot remember that and I would have to have opened the other table... a mess.
In Access you can use drop down lists... that is you would be able to see a list with the values of the relationship, or also, creating a current drop down list with your own values.
This is a very weak point from Base, and this should change.
Have in mind, sometimes, people like to use tables to introduce data inside, without using forms... so the drop down lists are very necessary.

The behaviour should be like in this video:
Comment 1 raal 2015-01-08 13:20:03 UTC
Valid enhancement , setting as NEW