displaying bounded column in text box

[ch90]

ciao tutti,

here's the deal:
1. I've two basic tables: one for computers, one for users. they're linked
trough a unique numeric id_staff
2. my report is based on a query based on the computers table
3. the query displays user names through a list box with a classic query on
the users table with the following parameters: 1 bound column, 2 column
counts, 0cm column width
4. I am stuck when it comes to display on the report user names in a simple
text box. I get only the numeric id_staff and not the names. I guess I need
to query it the right way (or used a query with both tables) but this is
where my technical know how stops.

I've done some homework but so far no good.
any brillant ideas?

chris90

 

[Duane Hookom]

All you should have to do is add the users table to the report's record
source query. Join the id_staff fields and add the user name fields to the
grid. The names should then be available in your report.

 

[ch90]

many thanks for this simple solution.
do you think there might be another with the query builder?

chris90

 

[Duane Hookom]

I think my solution was implemented in the query builder.