I have two tables which together, comprise formulas for making ink. I would like to set up an eep to run when a new color gets assigned to be sure the formula isn't already assigned another number. Here's an example of the data.
Table: ColorNumbers ColorNum Inkloading CY001CL 1.5 Table: ColorFormulas ColorNum Partnum Partratio Oilratio CY001CL 1212XY 10.5 NULL CY001CL 775258 2.5 NULL CY001CL 80888 NULL 80.00 CY001CL 80253 NULL 20.00 The combination of all the rows in ColorFormulas along with the InkLoading in ColorNumbers makes the formula unique. I can declare a cursor, convert the numbers to text and do a concatenation to get a text value representing the entire formula, but was wondering if there was an easier way. Thanks Dawn
