Yes Karen, you're right. Indeed it's the only drawback to the DBGrid. I do what others may do, I place a variable above the DBGrid close above to the actual field. What we need there is the ability to have a combo box on the actual DBGrid, show the part name but return the Part#.
Claudine ________________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, June 27, 2008 11:42 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: DB Grid lookup Claudine: Yes you can use popups to show a single column for an item that's in the DBGrid. But if you wanted to display the Part#, as he does, and next to it also show the part name, you couldn't do that. You could only show the one part# column as a lookup to the PartName table. You wouldn't be able to show both columns in the Grid, right? Karen 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
