468,783 Members | 1,628 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,783 developers. It's quick & easy.

Converting Numerical Value to Lookup value

Dan
I am using an expression in Forms to take several fields of data and
convert them to a block of text.

For one of the fields set-up as a combo box, it is based on a Lookup of
a separate table to text in a specified field. The table of data that
is looked up has 3 fields: Index [numeric, 1-12], Eng [Month of the
year in English], Fr [Month of the year in French].

When I concatenate the fields into the expression, the field for looking
up the month displays as the numeric value of the lookup table, not the
corresponding French or English value as it does in the rest of the
form.

What is the syntax required in expression builder to have a lookup table
display information from a specified column?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #1
1 1950

"Dan" <an*******@liamtoh.com> wrote in message
For one of the fields set-up as a combo box, it is based on a Lookup of
a separate table to text in a specified field. The table of data that
is looked up has 3 fields: Index [numeric, 1-12], Eng [Month of the
year in English], Fr [Month of the year in French].

When I concatenate the fields into the expression, the field for looking
up the month displays as the numeric value of the lookup table, not the
corresponding French or English value as it does in the rest of the
form.

What is the syntax required in expression builder to have a lookup table
display information from a specified column?


I'm not sure if I have the right angle here but if you have a combo which
gets its data from 3 columns then you can refer to any of those values by
syntax something like
MyCombo.Column(1)

The Column property is zero based so Column(0) would be the index, Column(1)
would be English etc.

Cheers,
Peter

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

20 posts views Thread by Brian Kazian | last post: by
13 posts views Thread by Gil | last post: by
5 posts views Thread by SMichal | last post: by
15 posts views Thread by allthecoolkidshaveone | last post: by
reply views Thread by zhoujie | last post: by
2 posts views Thread by Marin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.