I was wondering if you would be so kind as to send me the sample file also. I was also wondering if, in this sample file, it offers the solution to populate other fields depending on the value in a drop down...
I have a part name Widget1. The part number for Widget1 is ABC123.
On my order form, I want to be able to pick the part name and have the part number automatically fill in.
Yes and Yes. I have an Access database that I have all the part numbers, names, rev #s, process owner, etc.
This is a document control (DC) project. I need my DC coordinator to be able to Email Engineering Change Forms to the engineers, have them fill them out and return them. My goal is, if it can be done, to have DC be able to pick a part number and have the corresponding information filled in for them. This ensures consistancy with the names and such. Then, DC will Email it to the Engineer and they will type in additional information specific to the change and submit back to DC. I would like all the field content to go back and get stored in the database.
I have the trial version of Adobe 9 with Livecycle 8.2 and have 28 days left to figure out if I can do this or not before I can put in the purchase req. to have the company buy the upgrade (currently using Adobe 8 with Livecycle 8.0, which doesn't play with Office 2007).
I just need to know if this can all be done or not. I usually can find a snippet, of code, here or there that I can get to work, but I don't have the luxury of time right now. Any guidance you can offer, even if to tell me that it can't be done, would be most appreciated.
My biggest problem so far is that I need it to open with the fields blank until I pick the part number. My second biggest problem is having it add a new record to the database and calling the new form number (ECRNumber). This tutorial mentions to pay special attention to the auto-increment field so I'm keeping my fingers crossed. I'll have to let you know how it goes.
OK, I got creative with part of it. I only have one person that needs to fill in the doc number and corresponding information. Then she will distribute it to the engineer who needs it. They will fill out their portion and submit back to her.
What I did... I created a form (in Access 2007) with all the information that will need to go on the pdf form. I placed a hyperlink in my access db form that opened the pdf form. The pdf form is told to populate the fields with the last record of the sourceset. She will distribute and then it will get submitted back to her when engineer finishes filling it in.
The next step... getting the engineer's info into the database in the correct location... hopefully I can figure that out too!
So yes you can do what you want,,,,,,BUT - by using database connections on the form you will have to setup a Data source on each persons machine. The form needs to make use of this DSN to be able to acces the DB. Also the DB needs to be in a shared loacation so that each person can get at it and lastly if you intend to use Reader you will have to Reader Extend the form to allow Reader to do Database access (this can only be set by LiveCycle Reader Extensions not by Acrobat). Do you still want to proceed?
Getting the data from the form into the Access form will not be so easy. If it is only one user who is accesing the DB you can put Acrobat on their desktop and have the PDF add the records to the DB directly.
That is what I intend to do. (I do not need it to go into an Access form, just the database so that the information is usable for reporting). I haven't actually done a distribute/submit in Adobe 9 yet so I'm not sure how/if it differs from 8.0. If I can collect the 'submitted' forms and 'export' the info into the db in a sensible manner, I think that it will all work the way we need it too and everyone will be much happier than they are with the current system.