I would like to be able to auto-populate the field called O_RESERVE2 in the PWT_SETS environment with the TRANSMITTAL_NO which is generated after the transmittal has been created. In the Value tab of the attribute properties, under the 'Update Value' section, I choose 'Select' as the value type and put in the following select statement:
select TRANSMITTAL_NOfrom PWT_SETS s, dms_doc dwhere s.o_projectno = d.o_projectno and s.o_itemno = d.o_itemno and d.o_projectno=(select value from pwtopt where name='#$USER$#Receiver vault ID') and ??
I thik I am missing a line but I can't figure it out. Any help, please?
The steps for creating a transmittal are:
1. Choose documents to be transmiited and create transmittal using the Transmittal Set Wizard - this creates a set with the transmittal sheet inside the set
2. I go to the set and give it a transmittal number using the document code generation, to ensure the numbers are sequential and unique
3. I would like to be able to then open the transmittal sheet from the set, and, through document attribute exchange, have the transmittal number display on the page
Any thoughts on teh select statement are welcome.