Access shows ID and not NAME :(

[Natan]

Hey there,



I got an annoing problem - I made a report to show me data I need,
But instead of showing me CompanyName it shows me the ID.

I mean, I configed it to show CoampnyName, also, when I run SQL on design view it shows CompanyName, but in Report view it shows me CompanyID.

What can I do?

Thanks ahead!

[boblarson]

My guess is that you have lookup fields defined at table level, correct? If so, read this and remove them:
http://www.mvps.org/access/lookupfields.htm
If you don't, make sure to include the lookup table in the query for the report and select the companyname from the lookup table and not your actual data table.

[Natan]

My guess is that you have lookup fields defined at table level, correct? If so, read this and remove them:
http://www.mvps.org/access/lookupfields.htm
If you don't, make sure to include the lookup table in the query for the report and select the companyname from the lookup table and not your actual data table.

Hey Bob,

Yes, I have relationships over tables.
Are you saying that I should remove all my table relationships and make them a query relationships?

Thanks ahead!

[boblarson]

No I'm not saying to remove your relationships. What I am referring to is this:

http://www.btabdevelopment.com/ts/removelookups

[Natan]

I know how to remove lookups,
But What relationship should I set between tables? because CompanyName is not a key value...

And another question, I didn't find how to create lookup in query, how to do that?

Thanks ahead...

[boblarson]

How about posting a copy of your database. I think that might help us avoid a long, long back and forth having me ask questions about its structure.

[Natan]

Here's a copy of my DB.

Thanks ahead!!!

[rpeare]

Your company name has a digit in it, not a name (is your table in a non-english language because I'm getting a bunch of garbage in some of the fields when I open it)