[Solved] List box fields in report show only numbers

[adj]

I'm using several list box tables to make input easyer. ID numbers of the list box table are stored in the main database.
When a report is generated it shows the numbers from the database. I'd like to show the related fields from the list box tables.
Suggestions anyone?

[DrewJensen]

You would use a query to join the tables together based on those ID fields, then display the text from the joined table versus the ID value.

[adj]

Thanks for your quick response. Could you please explain a bit more. I'm a novice user of databases in general. Started to use base last week.

[adj]

I added a list box table and see the what you meen. Now I get 5 lines with the same data. With what funtion of criterium can I shorten this list to one relevant line?

[DrewJensen]

Well you need to JOIN the tables.


So in the query designer click on the field in the Main table that holds the ID to the other table, then drag this to the ID field in the second table.

When you let go of the mouse key you will see a line between the tables

Run your query again.

[adj]

Yes, thanks for your help!