I have a Crystal Report in which I have passed in two tables. One table (modeltags) contains the values I want to display on my form. Displayed are two fields, named term1 and term2, which are strings.

The second table (terminalcolors) is a reference table containing terminal numbers and their corresponding color, which I will set as the background color of the field.

My question is how I am to reference link this all together. I already have formulas within the fields to handle the strings that I get and convert them to the background of the field, but for some reason I can't get the term1 and term2 field to link correctly with the terminalcolors table.

Any help would be greatly appreciated.

MAC