Drop down list and look-up query

Discuss the database features

Drop down list and look-up query

Postby winston879 » Mon Mar 14, 2011 1:03 pm

I am having a challenge with migrating to Base (Ooo version 2.0) from Access and programming a drop down list. Hope someone can offer insight.

I have a form for the input of bibliographical citations. Each of the citations is entered bilingually French and English. Each of the citations is arranged under headings/sections that I want selected from a drop down list. I have a table as the source for the drop down list. A row from the table looks like this:

Code: Select all Expand viewCollapse view
id | categ_en | categ_fr
1 | Book Chapters | Chapitres du livre

[Sorry if this is was garbled. By the way I read the FAQ, BBCode table feature does not offer multiple columns.]

Coding objectives:

1. By making a choice in English, the same choice for the French category is displayed in the French field as well
2. By making a choice, the relevant section is stored in the table of citations under the same field names - categ_en or categ_fr
3. As well, by making a choice, the ID is stored in a field (called cat_id) of the citation table.

I tried doing this with the wizard but can not get it work properly. As I mentioned, this is a migration from Access and already have data in the citations table. The appropriate category is displayed in the English field but not the French field. The field for the ID in the citation table is empty for new records that are added.

If anyone can point me in thr right direction, it would be greatly appreciated.
OpenOffice 2.4 ???? Ubuntu 9.04
Posts: 2
Joined: Mon Mar 14, 2011 1:02 pm

Re: Drop down list and look-up query

Postby RPG » Mon Mar 14, 2011 1:37 pm

LibreOffice on openSUSE Leap 15
Posts: 2152
Joined: Tue Apr 14, 2009 7:15 pm
Location: Netherlands

Re: Drop down list and look-up query

Postby Villeroy » Mon Mar 14, 2011 1:49 pm

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Posts: 26142
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Return to Base

Who is online

Users browsing this forum: No registered users and 1 guest