Field is not pulling the right data
I have an odd problem here. I have a database that pulls and store customer information from the AS400 to the Lotus Notes. The form is called CompanyRec with Document as a type. From that form, I can create a Package Profile (PackageProfileRec, type Document, Formula inherit values from selected document) where the customer information (customer no, name, and address) are inherited from the CompanyRec. From the Package Profile then I can create a Work Order (WORec, type Response, Formulas inherit values from selected document). The Work Order will inherit the customer and box information form the Package Profile.
The problem at this point is, there are two customers with the same number. In the AS400 they are differentiated by a different company number. So the customer number is the same (i.e 123) but one is assigned on the company no 1 and the other company no 2. Those company no are not transferred over to the Lotus Notes database. So in the database there is 1 customer number with 2 different name, address, etc.
It becomes a problem because now in the WO when a user create a WO with that cust no. There are 2 customer information that are being pulled in the WO. The first thing that I thought is testing it by creating a new field to store the Company No (1 and 2), then add that information, then create a PP and WO. The weird thing is the company no got pulled correctly (only show up 1) but the name and address shows up 2 customers. I do not understand why because there is no lookup formula to get the customer information and if it simply inherit the value from the PP it should just pull out an information from 1 customer. Does anyone has an idea what I could try to fix this?
The problem at this point is, there are two customers with the same number. In the AS400 they are differentiated by a different company number. So the customer number is the same (i.e 123) but one is assigned on the company no 1 and the other company no 2. Those company no are not transferred over to the Lotus Notes database. So in the database there is 1 customer number with 2 different name, address, etc.
It becomes a problem because now in the WO when a user create a WO with that cust no. There are 2 customer information that are being pulled in the WO. The first thing that I thought is testing it by creating a new field to store the Company No (1 and 2), then add that information, then create a PP and WO. The weird thing is the company no got pulled correctly (only show up 1) but the name and address shows up 2 customers. I do not understand why because there is no lookup formula to get the customer information and if it simply inherit the value from the PP it should just pull out an information from 1 customer. Does anyone has an idea what I could try to fix this?
It does not make sense to me, at all. Some questions:
- at which moment exactly is the duplicate CompanyRec created?
- you pull data from the AS400 (how?), is that data correct, I mean, are all customer numbers unique on the AS400?
- you say that companies are differentiated on the OS400 by their company number, how is that in Notes then?
- can customer data be modified in the CompanyRec document, i.e. the customer number, or is it fixed?
- can customer data be modified on the AS400 side,and how is that reflected in Notes afterwards?
- at which moment exactly is the duplicate CompanyRec created?
- you pull data from the AS400 (how?), is that data correct, I mean, are all customer numbers unique on the AS400?
- you say that companies are differentiated on the OS400 by their company number, how is that in Notes then?
- can customer data be modified in the CompanyRec document, i.e. the customer number, or is it fixed?
- can customer data be modified on the AS400 side,and how is that reflected in Notes afterwards?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Found my own solution which is posted on my last comment
~Jon Snyderman