Hi Mark, > I have a form which contains a sub-form. The form is used for data > entry. I want to use a drop down list for one of the fields in the > sub-form. The drop down list takes data from another table not related > to the form or sub-form. I tried the following steps, but the drop down > list is never populated: > > 1. Change the field control to an drop down box > 2. Set the drop-down property of the control to yes > 3. Set the Type of List Contents property to SQL > 4. Set the List Content property to "SELECT "player_ID", "last_name" > FROM players"
That puzzles me: In the sample doc provided by Andrew, all SQL statements to fill the list boxes are like SELECT "column", "column" FROM "table" - i.e. the same column is selected twice. In the example you give above, you select two different columns. In fact the problem in Andrew's example database is caused by the duplicate names - so I wonder whether you encountered yet another issue? So, let me open this up again: Do you have a sample document which you can provide? 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]
