You could build a custom VBA function to handle this and then call the function in the query. The reference table is usually a better solution - easier to make changes, add colors, etc. And you don't have to list every color, you can use an OUTER JOIN (LEFT JOIN or RIGHT JOIN) and then return the original color when their is not value in the Reference table. Field: WhatColor: Nz([RefTable

On 8 Feb 2007 11:07:24 -0800, chezball@gmail.com wrote: So, my question, which I am sure you are already answering, is how do I map these RefID's to my Recipe, when each one will be a primary key, incremented in autonomy? The direction I am heading, which makes me shutter like fingers screaching down a chalkboard, is to make my Recipe Table look like: · Table: Recipes {RecipeID, Name