Show Field Output Name

[KarenS]

I ahve a table called occupation with 2 fields, one is ID (autonumber) the othet is occupation name.

I have another table with job info from sun to mon - with 7 fields for occupation lookup. e.g. monoccup, tueoccup etc.

I have a query and I pulled these fields into it, and the occupation names showed up, then I tried to build an expression and th output should have been the occupation name, but I'm getting the occupation ID.

The join shows occupation id from the occupation table linking to all 7 fields in the job table.

How can I get the expression to output name instead of ID?

 

[neileg]

Just add the field with the occupation name to your query grid.

 

[Phil_b]

how are you building the expression? Is it from a dropdown list? If so check that the bound column is correct.

If not then its probably (as above) just adding the field to your query.