You have this relationship:
One record in KitchenSinks matches to many quotes record and it also matches to many kitchenSinkColors records.
That means that any given Quote record with a value in Quote::SinkID will match to possibly many KitchenSinkColors records. Any field from KitchenSinkColors will show the first record of that group--exactly as you report.
Exctly what value is being entered into the ColorSerial field? the serial number of a record in KitchenSinkColors?
If so, you need to make a different occurrence of KitchenSinkColors and relate it like this:
Quote::ColorSerial = KitchenSinkColors|Selected::ColorSerial
Then you can select your field from the KitchenSinkColors|Selected table occurrence instead of from the KitchenSinkColors table occurrence in order to get the correct value in the name field on top of the ID drop down.
Worked perfectly! Thanks for the help.