Hi to All,

Currently in my project, people need to check if the value written in a dropdown field is a part of the value listed by an enquiry.

For exemple the field SECTOR in the CUSTOMER application list all the values from SECTOR APPLICATION, we attached an Enquiry to the field to get only 10 values from the SECTOR APP instead of the 20 existing values.

If the user choose to write the value in the field and that value is not a part of 10 values selected by the enquiry the RECORD can be stored without ERROR.

My need is to find a dynamic way to develop a validation routine that can check for each Field if the value written by the user is a part of the list generated by the attached enquiry.

Is there some object to access to the version or enquiry (in some cases to the BUILD ROUTINE result) for a current record that let me develop this control.

Thanks.

Hi: I think the only way is to write a VALIDATION ROUTINE and attach it to the VERSION(S) that update your CUSTOMER table.

Regards,

Hi,

Finally I found a solution for my problem.
I created an Input Routine wich access the R.VERSION global variable wich contain all the DropDowns used for each field. The target is to re-execute the enquiry using OFS MANAGER commands but the problem is when the dropdown has a predefined selection & especially when the predefiened selection is depending on other fields on the version, in that case we need to access to the STANDARD.SELECTION to get the exact Criteria (for System field as well for user Fields(localref)).
The routine is working perfectly but it still I can handel DropDowns in Next Versions.

For info
Mailto@ : This e-mail address is being protected from spambots. You need JavaScript enabled to view it

Regards.