Hello all. Here is what I am trying to do. I have table columns with names "ItemName" and "Description". In another table I have two columns "Assembly" and "AssemblyDescription". ItemName is populated automatically by QuickBooks. What I would like to do is populate the "Description" field in my query based off the "Assembly" value. So for example. If "Item Name" is "Blue" then the "Description" field will be populated with the "AssemblyDesciption" value if "Assembly" contains "Blue". Otherwise it is left blank. Thanks.