Well, I've struggled all day with this code and for whatever reason I cannot seem to get it to work or for that matter do anything. That's not a criticism of your code, it's all down to my ability to translate it into the database. That's my downfall! If you could elucidate a few more details of how to connect the tables, it would be much appreciated.
I presume from your spelling of colour that you are in the UK!