Linking a listbox to a database

English
,
#1

There is something that is not clear to me when linking a listbox field to a table of values in a database.

The wizard starts and you hato to:

  • select a database (ok!)
  • select a table in the database (ok!)
  • select a field within the selected table (ok, once again)
  • make an association between a value table ean a list table, and here is the tricky step

Why 2 tables? One is that in the selected database (isnt’it?) and which is the second one? how are fields defined in it?

I tried to understand it reading documentation but could not find an answer

#2

List boxes allow updating of one table using a list of values that can be derived from another table, or that can be created from a value list or query. Typically that would be done inside a form in base. I am unfamiliar with how a form control could be used in writer.

#3

Hi - The wizard is designed to be used primarily in a database. For example if we manage invoices, we want to display the customer list (customers table). The user selects the customer according to his name in the list and the customer code is stored in the table of invoices.

In Writer if you do not want to use you can disable the wizard by clicking in the toolbar on “Wizards on/off” but in this case after drawing the control you need to enter the properties of the form (data source, content type, content) and of the list (type of list contents, list content, bound field).

#4

Quite clear, thanks!

May be it would be worth while inserting a note on this in the on line help.

#5

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.