And thanks again, as that was my ticket to ride. On Tue, Sep 11, 2012 at 10:46 AM, William Stacy <[email protected]>wrote:
> Aha, the missing step. Thanks Karen, I'll give it a whirl. > > On Tue, Sep 11, 2012 at 10:41 AM, <[email protected]> wrote: > >> 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. >> >> >> > > > -- > William Stacy, O.D. > > Please visit my website by clicking on : > > http://www.folsomeye.net > > > > -- William Stacy, O.D. Please visit my website by clicking on : http://www.folsomeye.net
