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. 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]
