Table select field shows up as a number ot text

[LaughingBull]

I have a KidShop table that shows the Diagnosis for the person,
there are 5 diagnosis fields because one person could have up to 5 Diagnosis and each field is a lookup from the diagnosis table.
in the report they show up as the ID number not and not the text.
I inserted Diagnosis from the Diagnosis Table and a window popped up asking what Diagnosis from the Diagnosis table matched in the KidShop Table and gave the selection of Diagnosis 1 or 3 or 3 or 4 or 5. I could only select one and I selected Diagnosis1 in the KidShop table and that showed Diagnosis as text for the Diagnosis1 field but the other 4 diagnosis fields still show a number. I understand what that did but it does not give me the option to match Diagnosis 2,3,4,5 to diagnosis Table. If I changed the Data source for the other 4 to Diagnosis then only Diagnosis1 shows up it the other 4 fields which makes since.

any Ideas?

[June7]

Options for report:

1. use comboboxes with lookup - they won't be interactive but should show the descriptive text - actually sounds like you tried this and I don't know why you would get a popup

2. include the diagnosis table in the query 5 times, join 1 of each to each of the diagnosis fields, bind textboxes to the five descriptive fields from the 5 instances of the diagnosis table

Five diagnosis fields is not a normalized data structure. This will likely cause you lots more frustration down the road.

[LaughingBull]

I found the problem, the combo boxes were short text instead of a number after I changed them I just inserted them again into the report and now they show up as text. Thank you