Forms issue

HCL Domino Domino Forum
1

we have an application called MATCH (web form) in Lotus Notes. In this application, based on inputs (Bill-To sites/Ship-To sites/ Sales Order Number/ Customer Purchase Order Number etc.), we can search for the Order information.

The end-users are divided into different groups called Reps. Each Rep has access only for the records related to their group.

There were two Rep groups previously which were merged into one but the back-end data exists for the two old Rep groups and no data exists for the new Rep group.

When any of the users belonging to the new Rep group logs into the system, the Rep Name is automatically taken and based on the Rep Name, the results are shown. Since there is no data on the new Rep name, the data is not being shown.

We need to implement the code in the form to fetch the data from the old rep names when the user logs in with the new Rep Name.

2

Subject: FORMS ISSUE

Instead of changing the way your form works, you should write an agent that reads all the old data and modifies whatever field has recorded the Rep name, changing it from the old name to the new name. You might also want to have the agent record the old name in a new field for historical purposes, and make a simple modification to the form in order to show the this new field in addition to the old field.

-rich