Drop down list and look-up query

[winston879]

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.

[RPG]

Hello

Maybe the following links can help you.

http://user.services.openoffice.org/en/ ... 40#p164740
http://user.services.openoffice.org/en/ ... 39&t=38495
http://user.services.openoffice.org/en/ ... ox#p169255
Romke

[Villeroy]

No need to program anything.
[Tutorial] Creating a form in Design view

One-to-many relations:
http://user.services.openoffice.org/en/ ... p?id=10554
http://user.services.openoffice.org/en/ ... p?id=10524
http://user.services.openoffice.org/en/ ... p?id=10025

Several many-to-many relations with list boxes in tables:
http://user.services.openoffice.org/en/ ... 99#p180099