on 12-07-2007 10:54 AM
Is it possible to check if an ID has been alreday filled in?
I have a formatted search, but it is acutalised automatically when i change the bp-type. but i don't want that the ID is changed when i change the type from lead to customer.
is there any possibility?
Great, Philipp
Hi,
I had the same issue. I set up a query and FMS to automatically fill in the BP code when I vacated the Group field. Whenever the Group was changed, the BP code would change. (Note, this should also work with the name field)
After playing around, I came up with this scheme which seems to work.
Define a UDF, CustCode, and set up an FMS to copy the Cardcode into this field when you vacate the CardCode field.
SELECT $[OCRD.CardCode]
I then put an IF statement ahead of the Query that sets BP code that checks to see if the UDF is empty. If it is, the query is executed to populate the BP code and if it is not empty, the query is not executed.
IF Len ($[OCRD.u_CustCode] ) = 0
Hope this helps.
(remove the http://)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Philipp,
The functionality of <b>Auto Refresh when field changes</b> cannot be changed. This function cannot be made to behave different for different circumstances as in your case.
If possible, please send me your FMS code and I will take a look at other possbilities.
Suda
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
103 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.