Another one of those questions
Posted on 2006-05-19
Please take a look at the following scenario:
I have a database which has 3 forms.
Form 1 (Main Form) - Customer form
Form 2(Response Form) - Product form
Form 3(Response to Response Form) - Test form
Only one main customer document is created for each customer, however, for each customer many response product documents can be created and for each product many response to response test documents can be created.
To start using this db, we will be importing all the customer list, then at random, someone will start entering each product for each customer into the database.
What I need to do is the following:
Create an scheduled agent to run, everytime this agent checks to see if a newly entered product has a response test document, if not, to create a response to response test document and populate in it only those inheritence fields from the newly created response document. When the first response to response document(first test document for each product) exist in the database, it will then help us to schedule new test schedules based on dates set on it and then the engineer will create additional tests documents based on those schedules.
In short, is there a way to create an agent to run and test if a new product document has been created and created an initial test document for it?
Keep in mind that the initial test document is a response to response document of product? how would you create that in lotusscript.
I know that you can easily create a response to main, but i am not sure if you can use the same structure to create a response to a response document/
Thank you all in advance
P.S. I can see your 10 YEARS celebration logo on the page.