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
