I am guessing this is your problem: BasicGuide-630.2006.05.09.pdf Pg 669 " In forms viewed on the Web, if EXTERNAL() references a field that contains a qualification such as $Date 1$ <= 'Date 2', you must add double quotation marks around $Date 1$, like this: "$Date 1$" <= 'Date 2'. "
But you did not share your qualification so I am just guessing. :( -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On Tue, Jun 3, 2008 at 3:25 PM, Kemes, Lisa <[EMAIL PROTECTED]> wrote: > ** > > I have a form that has a table field. When I pull up a record on the UT > everything is OK, but on the MT I get the error "Data types are not > appropriate for relational operation (ARERR 313)" > > I understand what this message means, but not when it works on the UT and > not the MT. My qualification on the table is looking for a record with a > Date and Time field that equals the Date and Time field data on my form. > (same data types if you ask me) :) > > MT 7.0.1 patch 5 > UT 7.1 Patch 1 > ARS 7.0.1 Patch 3 > > Windows 2003 Server….. > > Lisa Kemes > AR System Developer > Tyco Electronics > 717-810-2408 tel > 717-810-2124 fax > [EMAIL PROTECTED] > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"