The method you are describing is to change a value from a lookup list. I need to display a lookup value in a separate column based on another column.
Example Table1 Columns Part# Description Table2 Columns Part# Quantity DB grid example columns Part#(table2) Description(lookup from table1) Quantity(Table2) I can do it a multi table view but then I can not edit it. Dan Goldberg -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Claudine Robbins Sent: Friday, June 27, 2008 9:06 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: DB Grid lookup What am I missing in what Dan wants to do? In a DBGrid, you can customize each field (column) from either Predefined Values, an Expression or a traditional Popup Menu lookup with where clause, etc... Razzak has a DBGridPickList demo db in the SAT 2007 applications which demonstrates this feature. Claudine -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Claudine Robbins Sent: Thursday, June 26, 2008 6:40 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: DB Grid lookup Dan, DBGrid|Object Properties|Columns|pick the column|Column Properties|Predefined Values|Expression or Popup Menu Claudine -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Goldberg Sent: Thursday, June 26, 2008 6:16 PM To: RBASE-L Mailing List Subject: [RBASE-L] - DB Grid lookup I want to place a column as a variable lookup from another table but have not figured out how yet. The user needs to be able to edit/add/delete rows. A sample of my db grid table PartNumber Description(lookup) Quantity A286 Computer 286 1 A386 Computer 386 3 Has anybody been able to do this?? I can do it with a scrolling region but the db grid is more functional and cleaner. TIA Dan Goldberg
