Hi,

In session form ,i am giving a zoom session to a field and returning its corresponding field.
now i need to accept the returnable field only from the zoom session .
If i manually enter other than that values it should not accept.
Is there any suggestions for this?


ex:--
zoom session for curr field is currency session. tcmcs0102m000
and its returning field is the currency field.

If i manually enter 123,its accepting.i want it not to accept other values.


thnq

Hi,

when the field changes, you can validate the input if it is a real currency or not by going to the currency table via SQL and compare the input with the currency.

- George

in the program script you can write the following code to restrict the user to do so.

field.fieldname:
before.input:
fieldname = ""

on.input:
select tcmcs002.* from tcmcs002
where tcmcs002.ccur = :ccur
selectdo

your code
selectempty
message("Currency Not Found in System" )
input.again()
endselect

Thank You George and KS KS...Its working now..