RE: Dynamic check in a Dropdown Field ?

[Jim Idle]

Bloody Google moderation software. I let this post through by accident because I pressed the preview button instead of the "reject and send poster to hell" button. Please do not answer it unless the poster reposts after reading the posting guidelines. Violators will be shot at dawn.

Jim

> -----Original Message-----
> Sent: Wednesday, November 04, 2009 2:00 AM
> To: jBASE
> Subject: Dynamic check in a Dropdown Field ?
>
> 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.
>
> I tried to search about R.VERSION record but no info available.
>
> Thanks in advance.