Table showing ID instead of data

**shaha** · 10-20-2011, 12:08 PM

Hello.
I found one thread that talked about this issue but there was no resolution.

I have my main table that has lookup field linked to another table. When data is entered, the main table shows the ID of the record instead of the actual data. How can I fix this? Thanks.

**June7** · 10-20-2011, 01:11 PM

You are working directly with tables for data entry/edit instead of forms?

**shaha** · 10-20-2011, 01:19 PM

No, I have forms made up and everything. When my users enter the data, and I go in the table to look at the data, it shows IDs instead of the actual data for the lookup fields.

**orange** · 10-20-2011, 01:25 PM

Are you using lookup tables at the table level?

If so, see
http://www.mvps.org/access/lookupfields.htm

**shaha** · 10-20-2011, 01:41 PM

Yes, my main table has a field that has a lookup to another table...
i know its not a good way but thats what i figured out at that time...how can i fix....i can send you my db...

**orange** · 10-20-2011, 02:06 PM

How big is the data base?
Have you ever created a separate lookup table?

Can you post a copy with no confidential data?

**shaha** · 10-20-2011, 02:13 PM

less than a mb....i will zip it...

**shaha** · 10-20-2011, 02:14 PM

here you go...

**shaha** · 10-20-2011, 02:26 PM

can you see in the table how its showing the id and not the number?

**June7** · 10-20-2011, 03:28 PM

My suggestion is to not bother with these settings in tables, I never do. I set these properties in the controls on forms.

Also recommend no spaces, special characters, punctuation (underscore is exception) in names. Name for table tblpart# should be like tblPartNum and field part# like PartNum. Also, no reserved words as field names.

I believe the issue is that the lookup tables are in the frontend. The BE can't find them. Put all these tables in the backend. The only tables that should be in frontend are 'temp' tables - tables that hold data only for the duration of a process and then are purged.

Will this project have multiple users or are you the only user? If only one user, no need to split.

**orange** · 10-20-2011, 05:14 PM

shaha,

When you post a question, you should be clear in what you are asking. At least provide the relevant facts about your issue as best you can.

You did not say you had a split database.
You talk about a table but you don't identify it.
You mention Id and Number but don't identify each.

It seems that June has identified issues that are most relevant to your situation.

In a split database, put all your tables in the backend. Pay attention to her points on naming convention, it will serve you well.

Good luck with your project.

Table showing ID instead of data

Thread Tools

Table showing ID instead of data

Similar Threads

query showing duplicate data

Data is not showing up in the form

Showing data from different queries

Text Box in report is not showing all Data From Table

Data Not Showing in Reports

Posting Permissions