Hi Peter, > there are at least two ways to show data from another table in a > gridcontrol: either a table or a select statement. > > Assuming the first column in the other table is an id (foreign key in my > gridcontrol table), the second column is the value I want to show in the > gridcontrol: > > Is it the correct that: > > * this is not possible with using a table, whatever value is set to > the property bound field. > The table shows always the value of the first column. > * this is only possible with a select statement, if the the first > column is specified as that one I want to see in my gridcontrol.
that's correct. That's one of the history quirks of the list box - the "display column" is always the first column of the result set which is used to fill the list. Ciao Frank -- - Frank Schönheit, Software Engineer [email protected] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
