Does the data always have exactly two PartRatios and OilRatios? --- Dawn Oakes <[EMAIL PROTECTED]> wrote:
> 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 > > ===== Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
