Fetching Contents of a previous document in the current document
hello,
i'm making an application where i want to attach a previous document so that the fields in that gets reflected in the current document..
Eg: -
i save a document which has a "status" field with value "Open", and one with status "Closed"
I want the document with status "Open" to get attached in the current document...
If anyone cud gv me suitable answer....wud be highly obliged
Software/Hardware used:
Software/Hardware used:
ASKED:
January 20, 2009 5:42 AM
UPDATED:
January 20, 2009 3:25 PM
Answer Wiki:
It depends on what you mean by "attached." It sounds like you are talking about versioning to me. In the Properties for the Form, in the Versioning section, choose "Prior versions become responses." Every time someone edit and saves the document (the Notes record), a new document is created. The version of the document prior to the save becomes a Response to the changed document. I have only used this feature in a database once.
To see all answers submitted to the Answer Wiki: View Answer History.
Another approach is to inherit the values of the “Open” document into the “Closed” one as it is created. There is a checkbox on the second (propeller-head) tab of the form properties. If you have the Open document selected and then create the closed document, it will bring the values forward, based on matching fieldnames. You can also manipulate the values through formulas.
Not a better or worse solution than Brooklynegg (who certainly has a track record for good answers) — a different approach that may or may not fit your needs more closely.