This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello -
I am new to Access and have been beating my brain and wasting A LOT of time trying to figure out how to correct a problem. I'm using a form to create records which are then linked to a table. The problem is that in my form, the fields all show text, but
in the table, in reports, etc, the text is being converted to the ID number rather than text. For example, a tour record for Belville Elementary is showing up as "30" in the table of "Tour Records" rather than the name of the group. The same thing is happening
with another field (Tour type) as seen here. I've been trying to figure out how to fix this, and am getting nowhere. Can anyone help?
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
It looks like you managed to create two fields with the same name and that is what is confusing things.