Different savings of field values

Hello DevDom,

sometimes Notes drives me crazy …

i am developing a WEB-Application :

Topics :

  • a view, containing different products, categorized by product-group

    the name of the prod contains “name”,“size” and “colour”, seperated by “,” (komma)

    this prod-name is plced in a column

  • a form, containing 9 control-fields (one for each product-group)

    by starting the form, the control-fields display all prods of its group, so that you can check one or more products

  • by saving the form/document, the following happens :

the prods of control-field one and five save proper, the dedicated view displays the prod-name right “name, size, colour”, separated by “,”

All other fields uses the komma as a seperator, so that the view displays a multiple field-value.

So, by opening the saved document, following is displayed :

in prod-cat 1 and 5 the correct products are checked, in all other cats theres no prod checked, which contains a komma (logical, because theres no field which label contains only the prod-name)

All control-fields contain the same @dblookup-formula, even the category number is different.

All field-formulars were set by copy and paste (form field 1, which works !)

I tried the following :

a) normal use - above described happend

b) adding a komma to a product in prod-cat 5 - this works proper

c) deleting a komma in a product of cat 2-4, 6-9

  • this works proper

d) deleting a komma in a prod as ment. in c), typing in a new komma and saving - the same prob as mentioned above

Why does notes split a field value in some fields but not in all, although the source-view is the same and the formula is the same.

Can anyone HELP me ???