Cascading combo boxes show correct data but stores ID number in table.

[RolandC]

I'm working with cascading combo boxes for vehicle data entry. On the form the combo boxes work correctly and display the correct information.
However, it stores the corresponding ID number instead of the vehicle make. I have been searching for the answer for over a year now with no solution.


I have attached a Sample DB. My main goal is to be able to print out a report from "vehicle data" that displays Make, Model and Trim correctly.
Again, I've been working on this for over a year and have tried everything possible that I find or test. I appreciate any input that may work.

[Micron]

I didn't download. No doubt you have the wrong combo column bound to the table. By ID I guess you mean that has something to do with the vehicle info and not the autonumber record ID? You would not want to try and insert that from a combo. Check which combo column is bound to the table and try another column instead. How many columns are in the combo (visible or not)?

[Micron]

Good thing I took a look. The way you have it is the way it should be. The pk of the parent table should be going into the child table as a foreign key (as you have it). That is, Make pk (4) is Buick. You store 4 in the vehicle table, not Buick. If you changed a field in the parent table (e.g. you noticed that you entered Biuck (sp) and had hundreds of records already, when you fixed the spelling you'd have to make sure all existing records got changed.
I think you should review db normalization samples that show this, although one would think you already have since you're doing it properly.

[RolandC]

Thank you for the response. Didn't notice the misspelling which usually is the first thing to check when things aren't working out. That DB is just for testing purposes anyway, (so I don't break anything in the DB it will eventually reside in).
I'm pretty sure that I've tried every column combination possible. Sometimes you end up trying so many different ideas that don't work you start to assume it will never work, or you're missing the obvious.
I'll be trying more over the weekend at home. There is an answer out there somewhere.

[Micron]

You've lost me. I don't see any issue. Maybe I'm missing something. Perhaps explain what you expect vs results.

[moke123]

My main goal is to be able to print out a report from "vehicle data" that displays Make, Model and Trim correctly.

You would need to join the tables in your reports recordsource like so:



I made a few changes to your datatypes. See report 1

[RolandC]

Thank you very much. That's exactly what I was looking for.