Deciding which Column ti display in my look up?

[Maillme]

hi there,

I have a combo box, with a look up - it is looking up a table:


tbl_locations_sri

this table has 3 columns:

sri_location_id
sri_ward_number
sri_location_name

when i use the combo, it displays the ward number and the location name field (which is what i want).

But, when i click my choice, it only displays the ward number, and i would rather it displayed the location name.

How can i change this?

many thanks,

Neil

 

[GingerR]

it will display the left-most visible column. you can make the combo box rowsource be a query where you put the columns in the order you want them, OR if it's feasible, concatonate the ward number and location name into one calculated field in the query, then you'll see both.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[Maillme]

Hi There,

thanks for the reply.

well, to make matters more complicated - my row source is changed depending on what choice the user picks in a group of radio buttons (there's a choice of 2).

and how do i do this:

"concatonate the ward number and location name into one calculated field in the query"

Sorry, but i have very limited experience.....

thanks alot for your help,

Neil

 

[PHV]

What is the actual SQL code of the combo's RowSource ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[GingerR]

Try looking up "concatonate" in HELP.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[GingerR]

As I explained, it will show the left-most VISIBLE column. So you can write your queries/row sources to have whatever it is you want displayed be the first visible column.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html