Field conversion to an ID
Posted on 2002-06-26
I had previously had a question that zvonko assisted with. Converting an inputted value processid like A-P-010 and the formula behind this field did a hidden view lookup xref to match this processid to a number like 384. Then the number 384 was associated to a preview button that would take you to the server and bring up a word document that had the name 384.doc and contained the prodcess details for that entered processid. The formula behind the field is :
Then a preview button that takes this configvalue like:
A-P-010 | 373
and goes to the server and references 373.doc. he problem I have encountered is that the processid field stored on the database is the number 373 not the actual process id. Therefore, when the processid and matching reference number changes, I have no way of rereferencing the processid to a new number because the processid no longer displays in the field and the number is different.
Any ideas !!!????