Re: Base: How do others than the first fields in form?

Hi Klaus,

> I have an adress table, and I want to create a form with a list box 
> for the selection of country names. There is another tabel with an 
> automatic ID, country names, and the postage rates for a letter there. 
> The postage should appear in the form when one of the defined 
> countries is selected from the list box.
> 
> What happens is that the list box shows the first column of the second 
> table only (which happens to be the ID number). How do I show the 
> entry of the second column (country name) there and of the third 
> (postage) in another field next to it?

You need to base the list box on an SQL statement, not on the table
itself. By definition, the list box always displays the first column of
the underlying list source - if this is a table, it's rather random
which one is the first one. So, use "SELECT name, ID FROM table" as list
source, this way forcing the box to display the "name"s.

Ciao
Frank

-- 
- Frank Schönheit, Software Engineer         [email protected] -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Database                   http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -