Argh! Lookups...

[ply@lockton.com]

I've got a query set with 3 fields. Query comes up fine. I tried to do a lookup of the query fields on a table - and 2 out of 3 fields come up as they should. The 3rd field comes up with a number rather than text.

Query shows:
Client Client ID P&C
Client Client ID P&C
Client Client ID Bonds
Client Client ID Benefits
Client Client ID Bonds

Lookup Field should show:
P&C
P&C
Bonds
Benefits
Bonds

But instead shows:
1
1
3
2
3

Any ideas on why it's pulling the index number rather than the text value? How do I fix this?

 

[SydneyGeek]

In the Properties of the field (you're in a table, right) -- go to the bottom.
Click the Lookup tab. The top line probably shows Combo.
The RowSource (or is it RecordSource)? shows a query (SELECT ....)
The ColumnCount row will probably be 3, from what you showed in the example. Anyway, it should be greater than 1.
The Column Widths will be a sequence of numbers separated by semicolons. Make the FIRST number 0. That hides the key field and displays the second. If instead you want to display field 3, make the first two widths 0...

HTH
Denis