On Sun, 31 Jan 2010 22:25:38 -0500, Drew Jensen <[email protected]> wrote:
[...] > Sorry to say you didn't miss anything in your search. Multiple column > display in list is not supported. You can display 1 field only if you > want the display list to contain data from multiple columns then you > must assemble the single text column in a query: > SELECT "Col1" || ' ' || "Col2" AS "DisplayText", "ForeignKey" FROM... > Which brings up another piece of info. > The list or combo box always displays the first column, the data field > in the target table gets the second column or higher. > Of course you start counting at zero in programming and you should > know that (lol), so in the property editor you set the bound column to > 1 or higher. > Now the above SQL sample is not going to be adequate for real use, you > want to account for nulls, formatting, etc. Thanks for the clear explanation! I'll think of how to construct a proper statement to concatenate the relevant fields to deal with this. Are there any plans to support multiple columns, instead of having to do all this? Cheers, -- Seb --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
