I have several forms that each contain like fields in them, and it would be nice to be able to populate these fields based on a previous form submission.
For example: A user fills out a form about a new hire. A month later, that user needs to update some information on that new person. So they pull up the Modify Person form. Whether than having to input all of the info over again, while making some changes, it'd be great if they could enter a name or past ID number and have the info populate.
I've looked into the usm_request_item_form table and found what I need, but it is stored in a format that I can't access.
I've also been reading about ca_reportQuery which seems like this is doing what I want to do, but I don't really understand it.
Am I looking in the right place? Am I even on the right track?