Am Montag, den 17.09.2007, 14:13 +0200 schrieb Frank Schönheit - Sun Microsystems Germany: > Hi Marc, > > > In the Subform I wanted to make one column a other-table-lookup-type, > > like using the column "ItemNo" for looking up the item short description > > and price in the third table "items" and show that as the table controls > > column value (the visible text). I didn't get there ... please help or > > tell me it's impossible. > > a list box column with > Data Field = ItemID > List Content = select "short_name", "ID" from "items" > List Content Type = SQL > Bound column = 1 > > This results in a list which contains all short_names, using a mapping > from the ItemID of the current record (thus from the current order_item) > to items.ID. > > If you additionally set the column's Enabled property to "No", it will > be for mere display, without the user being able to change the value.
Yes, that way it works as expected, many thanks. I actually made two common errors: leaving out the quotations around the field names and omitting the ID-field from the query (I should have known - no, actually I do know X-). Marc --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
