Quick Question

[pikoy]

I have a table where my values are based on. The table has two columns one for ID (Key ID) and on the other column the data. How can i display the value instead of the key ID. When i direct it to the field for the control source, it picks the ID and when i change it, it gives me a parameter error.

Column one - ID.
Column two - Entity

This code give me a parameter error

SELECT T_Entity.ID, T_Entity.Entity FROM T_Entity;

If i put in Entity in the control source it will bring me the ID instead of the actual entity value.

any help will be greatly appreaciated.

 

[pbaldy]

Presuming that's a combo box, typically the first column would be the bound column but hidden (zero width).

 

[pikoy]

Presuming that's a combo box, typically the first column would be the bound column but hidden (zero width).

Thanks for the reply Paul.

But I did that and on the table it works properly - showing me the data value using this code

SELECT T_Entity.ID, T_Entity.Entity FROM T_Entity;

For some reason, when i get to the reports to bring it up, i get the ID (key)

 

[pbaldy]

I assume the ID is being stored in another table, which the report is based on. That is normal and recommended. What you do is base the report on a query that joins the 2 tables together, enabling you to display the value instead of the ID.

 

[pikoy]

I assume the ID is being stored in another table, which the report is based on. That is normal and recommended. What you do is base the report on a query that joins the 2 tables together, enabling you to display the value instead of the ID.

Yes. The Combo Box on the Form that looks at the entity table, stores the data into a different table using the ID. I will try the query joining those two...

Thanks.

 

[pikoy]

I assume the ID is being stored in another table, which the report is based on. That is normal and recommended. What you do is base the report on a query that joins the 2 tables together, enabling you to display the value instead of the ID.

I did it using a query that i have that looks at all the fields in a table and performed the join there and created a report thats based on that query.

It worked.

Thanks Paul.

 

[pbaldy]

No problem, glad we got it working for you.

 

[pikoy]

No problem, glad we got it working for you.

One more thing, this has me confused. When i performed the join the Entity Value is now showing but it narrowed down my table as if there is a filter - do you happen to know why?

I dont have a filter on any of my tables nor queries.

 

[pbaldy]

If there are ID's in your "transaction" table that aren't in the lookup table, the default join will limit the records returned. If you have the query in design view, right-click on the join line between the tables to edit the join. Choose the appropriate "Return all records from xxx...".

 

[pikoy]

If there are ID's in your "transaction" table that aren't in the lookup table, the default join will limit the records returned. If you have the query in design view, right-click on the join line between the tables to edit the join. Choose the appropriate "Return all records from xxx...".

Thanks Paul... found the issue. it has something to do with my reference table