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.