OK, as a novice it appears that I have sinned. I created tables that have lookup fields referencing another field. Actually I have several tables that all have relationships and object dependencies in my database. Now that I am trying to create some different reports, when I run the report I get the ID rather than the contents of the field.
Also, I have a 'Report Dashboard' so to speak that I can run different reports from. On the form I have Combo boxes that reference one of the tables. I can generate the report showing the information, however I tried using a text box (criteria)(=[Forms]![Reports Form]![Combo47]+" County") in the header of the report to reference the selection made in the form combo box. When I run the report I generate the ID in the header.
I guess, first how do I get rid of the lookup fields in the tables, or is there another work around?
I am completely a novice and I have been learning as I go.... Any help would be appreciated. Thank you
Also, I have a 'Report Dashboard' so to speak that I can run different reports from. On the form I have Combo boxes that reference one of the tables. I can generate the report showing the information, however I tried using a text box (criteria)(=[Forms]![Reports Form]![Combo47]+" County") in the header of the report to reference the selection made in the form combo box. When I run the report I generate the ID in the header.
I guess, first how do I get rid of the lookup fields in the tables, or is there another work around?
I am completely a novice and I have been learning as I go.... Any help would be appreciated. Thank you
Lookup Fields and Tables
