Help with numbering agent
Posted on 2004-08-19
Well I have inherited another mess
What I would like to do is add a unique number to documents created with the Purchase Requistion form. I will create a new number field PRNumber
This is easy enough to do when new, however there are several already created dox. Part two of this is that there are several dox created with the Purchase Order form that are related to the PR's. They are created by a button on the PR when all approvals have passed. When the PO's are created the pr_link1 is populated with the UNID of the PR. The unfortunate side of this is that the original creater of this db did not use response dox.
There is a field on the PO's that captures the UNID of the PR, pr_link1
There can be several PO's related to the singular PR.
I would like to have an agent that will
a) capture the UNID of the PR
b) locate that UNID in a view that contains all the UNID's that are in the pr_link1 field that match the PR UNID
c) add the new number of the PR to the pr_link1 field
I am thinking this is a two part solution
Fisrt create the PR numbers then run the other that will change the fields as outlined above
Any help or thoughts appreciated