Values in a combobox

[kbp]

I have created a form with a combo box on it. I want the combo box to hold a list of titles, but the data to update the id of the item selected?

i have been playing around with it, and can't work out how to do it.

i have 3 tables

[job]
id, details, employer, location

[location]
id, title, description

[job_location] to join the two together


id, job_id, location_id, description

so job has the job details
location has a list of locations
and [job_location] has a the (id)'s from the other two tables and a description

basically on the form i want a button that inputs the id of the location into the job table, but i want to see the titles (london, new york, paris) as opposed to 1,2,3,4 etc

any ideas how this is done?

cheers Andy

[NoellaG]

Hi,

try playing with the combo box properties:
* set the Rowsourcetype to Table/Query
* set the rowsource to a query or SQL expression that gives the ID in column 1 and the description in column 2
* set the bound column property to 1
* with the format properties set the column count to 2
* set with the column widths property the width of the first column to 0, the second column to the widht you want to show.

The combo box will use the value of the first column to fill the field, and show the value in the first column with a width > 0

success
NG

[kbp]

cool, i was thinking along the same lines, but was wandering if it could be done another way.
I'll have a go and see what happens

thanks loads
andy