I am trying to display a message in a Form based on the following: 1st Variable - vthis_hub <= 999999 Note: This is not in a table during data entry just in the form and the variable. Next: FROM Customer WHERE Custnub2 = .this_custnub2 and ParentCustId = 105
Tried to do it the following way, but can not figure out how to combine a variable not in a table and data from a table. -- Warranty.rmd -- Set variable vwarranty -- Used to remind a user to Check A Spread Sheet for Customer Equipment Verification -- Major Assumption - var This_CustNub2 is set on form entry -- Major Assumption - var vThis_hub is set on form entry Clear var vWarrant SEL COUNT(*) INTO vrows INDIC iv2 where vthis_hub <= 999999 (?) and FROM Customer WHERE Custnub2 = + .this_custnub2 and ParentCustId = 105 IF vrows > 0 THEN SET VAR vwarranty = 'Check warranty coverage for the unit before handling Breakdown' ELSE SET VAR vwarranty = 'TEST' ENDIF RECALC VARIABLES RETURN ny recommendations? Stephen Breen CDI Services, Inc.
