Query with combo box

No on both counts.  Sorry.  See rants here.

I am trying to create multiple combo boxes in a form that once a value is selected, the next combo box updates and only shows related data to select from. I have that working with each combo box referencing the values and proper index number for this to be possible. My issue is of the three updatable combo boxes, once I enter the data into the table, after I created the new record, the first field that gets its data from the first com box always enters the index id value and not the word. So, if, for example, I was using the value "1" with the word "Auto", I have the combo box set properly to show the word "Auto" but after submitting the changes into the table, the field that the value goes into shows a "1."