Report showing numerical value where there should be text

[eepok]

Hello yet again amazing people,

*Disclaimer*I'm familiar with database design and have made many a fabu DB with FMP, but an still unfamiliar with the Access versions of DB vocabulary.

Ok, this database is nearing completion and I'm just working out the reports. Just one snag: I need to show the publisher of a book, but it's only showing a numerical value.

The form works, no other fields are having this problem.

I have a table with publisher name and standard contact info fields. I use the publisher name column to populate a list for a value list drop-down (list box?) used in another table's form. The name of the publisher is stored in that form.

Simplified

Table 1: Publisher info

Table 2: professor, course, class size, book needed, author, publisher name (populated by table 1), etc

**Edit** I just figured out that a numerical value is being put in the place of the publisher's name in Table 2.

I missed something here. Anyone care to put me in check?

 

[eepok]

Ok, you may learn this about me in the future. When I'm stumped, I'll ask a question. Then, when I ask the question and know I'll get a good response, I get ballsy and start trying things... and sometimes they work.

This time it did. I was referencing the ID and not the right field. Clear as day, obvious, I know.

Thank you for being a muse, guys.

 

[gemma-the-husky]

you got it then

the syntax is

listbox.column(x)

where x is the number of the column in the underlying query. (the first column is column 0). Note that you can deliberately hide columns by setting the width of the column to zero