Unfortunately no. There can be unlimited partratios, but generally no more than five, sometimes just one. One to three oilratios.
-----Original Message----- From: Albert Berry [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 10, 2004 4:20 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Checking for duplicate - multiple rows 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]
