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 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
