I've got two combo boxes that work really closely to what I want, but they've still got 2 problems:

(1) When you make a selection with one combo box, the value of the other combo box should be (programatically) set, but as it is now I have to select the right value from each combo box individually.

Both combo boxes get their values from the same table, same record, but different columns, so it seems easy that when the value of one combo box gets set, the other should too automatically.

(2) Both combo boxes have duplicates in their drop down lists. How do I fix that?

My database is attached.
-Thanks!