Hello -

I am running across a problem with my data types and my indexed fields. When I created my application, I set my primary keys in each of my 9 tables to numeric (Primary index). And, I set each of my indexed fields in my tables to numeric as well (Regular index on each of those.

The problem arose when I started workind with combo boxes and selecting choices. I instructed the combo box to show the id number for one field and the "name" in the other.

For example: When you select the drop down in a combo box you would see>

1 WOOD
2 PAINT

and so forth....

When I selcted a choice, the numericid is placed in the text box, not the word. The reason of course is because everthing is set up for numeric data type for all indexes. It will not allow me to put text in the box.

What are my options to alleviate this problem? I thought I could just go in and change all my regular indexes to character data type, but I can't join together indexes that don't have the same data type, can I?

How do most developers set up their indexes?

Do you use the numeric data type for all indexes? Character data type for all indexes?

Is there a way to change the index, but leave the data type numeric?



Thank you in advance for any help.

Jason