This is really ODD and hoping someone can point me in the right direction. Sorry about the size of this document but I’m really at a loss of what’s going on.
Was asked to update an existing Lotus Notes Application with a field called Categories. Categories goes to a keyword view to give a list of values to select. However, when you select one of those values and bring up the picklist again, it’s like the system took the value you selected - explode it by space and add that to the pick list:
Here you can see what it looks like:
I select any of the keywords, A- Canadian Economy everything looks good:
If I then click on the Dialog List helper icon again the list now shows (no save or refresh was done by me):
Say what???
If I save the document and look at the Categories field value it’s “A - Canadian Economy”.
My first assumption is something was up with the Input Translation or Validation. However there is NO code in either:
I did check them all manually to just be sure (both Web and Client)
Then I thought it was a piece of code somewhere on the form, maybe on QueryModeChange or PostReCalc. I ended up removing ALL the code in all the events on the form. I still saw the same results.
Then I thought it was a propety on the field. Looking at the Categories field properties you see:
Then I figure it might be some code I was missing, so I did a design Synopsis and didn’t find anything special that was updating the field Category. On the form or in the Script Libraries.
To really check this out I RENAMED the field - and stil got the same results. (Called it CategoriesORG)
I then also created a new field called Categories and this field DID NOT have the same problem. As near as I can tell EVERYTHING about my new Categories Field is the same as the CategoriesOrg but it just does not show the same properties.
I then copied and pasted CategoriesOrg to get CategoriesOrg_1 and this field has the SAME problem.
To me, that proved that the “issue” must be a field propertry or Field Method.
I then went through all the methods to confirm there was NO CODE as shown. I did NOT find anything.
I then copied the field to a NEW FORM with just the field on it and it still shows the same results.
What am I missing?? Why does it look like the field is exploding the value I selected and including that in the pick list?
Oh just to be complete here is the view. Nothing to include the document I created. Nothing to explode things…
For now I’m just using the field I created, but given this db was designed by someone else, long gone, I’m just wondering what I am missed. Showed it to some of my co-workers who have no ideas either.