Converting numbers back to text?

[yepwingtim]

http://img404.imageshack.us/i/relationship1.jpg/
http://img687.imageshack.us/i/relationshipu.jpg/

I want vendor info to pull the text instead of the numbers

is that possible?
________
The Girls Next Door Dicussion

 

[SOS]

Again, I can't see the images because you've uploaded them to a site which blocked at work. Why don't you just upload them here? You can do that you know.

 

[yepwingtim]

i uploaded it via here thanks~
________
Free porn vides

 

[SOS]

The number is what should be stored. The text should be able to be displayed if the underlying record source has it there. You need to set the Combo Box's Column Count to the appropriate number and the Column Widths property to what you want to see - like 0";1";0";0" for example if you had four columns and wanted to see the second one.

 

[yepwingtim]

i want the numbers converted to the text from the drop down menu

nobody will understand the numbers unless u go to the table to see what references it

thanks again
________
Vapor genie review

 

[CEH]

Search the forum.... try this one..... http://www.access-programmers.co.uk/forums/showthread.php?t=94377
And on a side note...... I looked at your images... I would highly discourage using "ID" for every primary key...... Going to get you in a LOT of trouble!