In one of the formfield of the salesorders I want people only to be able to fill in customer-field the value between "B00000" and "B99999"

The field goes to "Dispaly Customer list"
There are more customers than jutst the B-customers.

I stried making an expression on the formfield, but I can't get it working.
one way I can fill in anything. The other way I can't even thouch the field anymore. . .

Can somebody help me out here please.

Thank you very much in advance.
Dennis

Hi dleijdekkers
IMHO there are two ways: table field data authorization
or check input in section check.input :)

Thank you very much,
What I try to do is via "Maintain Form Field Data" to create some kind of an input condition so it will be blokked.

This way I would only need to do it once instead of giving every user table field data authorization.

The section.input is prob. when I could change the programming of the script? Or am I wrong? (we do not have the scripts for the session)
Otherwise I would like to hear where I could do that.

Thanks again.
dennis

This is an example where one of the customization tools such as RMCgen (http://www.rmcis.com/rmcgen2.html) or QKey would be very handy. You would simply add your own critera to the check.input section for the field. There is no need to have the standard Baan source.

If you do not want to change script (Vamsi started a BIG tool called Rush, thanks him) you might change a table :) create new table with allowed cunos and change reference from sales table to yours and from yours to tccom010

Another way - try to change domain on table field it must look like tccuno but has your limitations. Maybe that will work?

The problem is that these standart tables is frequently modified by support :)

It's very interesting but it works

Inp\Ref for xxyyy999.cuno field:
xxyyy999.cuno:=(xxyyy999.cuno(1;1)<>"B")?"B00000":xxyyy999.cuno,1

Check that B00000 client was not in tccom010

It is definitly very interesting. . and it does the job.
Thank you very much.

Is there anywhere were I could find more information about the possibilities on the things you can put in Inp\Ref.??

Again my thanks it is fantastic!!
Dennis

I've just used this topic (http://www.baanboard.com/programmers_manual_baanerp_help_functions_expressions_runtime_expr_compile)
The problem is that this field has length limitation

Thanks!!

I have added this to my list of Favourites
Dennis