Combo Box and Crystal Reports

[bgoodwin23]

All,

I'm a novice at best with Access. I'm currently on Access 2003. I've created a database (obviously) and used a combo box to make it easier to choose and display the data represented in another table. This works fine. However, when I look in the second table the data stored is the ID rather than the actual text. When reporting or doing anything from the actual table it represents the ID number rather than the actual text (similar to a normal text field).

I've played with the control source, changed the data type to preform a lookup for the values, and many, many other option with no success. I would like to store the actual text data not the ID number; but for some reason I get the ID number rather than the actual text.

How do I get the text to appear in the table and subsequently in my report? Do I have to write a query? UGGGGG!

I'm not a VB programmer nor am I an access guru so any help would be truely appreciated.

Thanks in advance.

 

[pbaldy]

What you describe is the normal and recommended setup, and yes, you would use a query to join the tables and get the text. Won't say you can't store the text rather than the ID, but IMHO it would be a mistake. Play with the query designer, and I think you'll find it's relatively easy to create queries.

 

[bgoodwin23]

Paul,

Thanks, I appreciate the validation. I started messing with this late last night and figured it out.......

Take care,

Brian

 

[pbaldy]

No problem Brian, and welcome to the site by the way.