I'm sure I understand, but I'll suggest this: If you want to combine
a variable from your eep with some data from the table, then in
your form create a form variable for the data you want. In Variables,
Add/Edit, create something like this:
vPartNumber = PartNumber
This grab the value in PartNumber in the row that you are on in the
form. Now you can reference vPartNumber in your eep's message.
Karen
> 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
>
