displaying bounded column in text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
many thanks for this simple solution.
do you think there might be another with the query builder?

chris90
 
Back
Top