Also he is using "from" instead of "in" in the lookup expression..
----- Original Message ----- From: <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Tuesday, September 11, 2012 1:41 PM Subject: [RBASE-L] - Re: Can I put a variable or expression into acellofanenhanced... : Here's what I've done. Go to the column's property page, "enhanced : properties" tab. Make sure "lookup expression" is selected under field type. In : my case I had a column called ClientID in my table, and I wanted it to look : up the client name. So under "expression" I have this: Description IN : clients WHERE clientid = clientid : : When I tested in this an earlier version, the only thing I didn't like is : that it did let me type in a different ClientID in the column, but it didn't : show the corrected description until you left (ie: saved) the row so it was : kinda confusing. Perhaps the behavior has been changed. : : Karen : : : : In a message dated 9/11/2012 12:35:21 PM Central Daylight Time, : [email protected] writes: : > I spoke too soon. Nothing of my attempted expression building in there : > is working or being saved. The only thing I've accomplished so far is the : > column captions I've attempted to work with have a little darker button than : > the rest of the column captions. Not much progress on this today. --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
