I posted these questions last week, but have not heard any responses. If any of you think I am doing this for profit for my work, fear not... I work for a state agency which has no funds for special functions on any software program they provide for our office. If it was not for me, our staff would not have any forms, special spreadsheet programs, or mainframe macros. So If I don't figure it out, we do not have it.
Once again, I find myself in a pickle. I had a word - Leave Request form for 7 years which worked perfectly. The staff would initiate it, filling the form, and then submited the form which would travel via e-mail to their Supervisor. The Supervisor would approve or disapprove the leave request, the approveal sent the form to our Ops Coordinator who again either arrived or disapproved the Leave, if Approved again, it posted to our centerwide database and forwarded to our Admin dept who then could file the request. All without touching the ground. Then State Office decided to move to Office 2003, well now all my Outlook & Word Forms are dead in the water, because Outlook strips the code from forms.... I'm stuck with InfoPath.
I have attempted to create something similair in InfoPath, but am have problems with several stages.
1. If I select a Query from our Leave Database to populate upon request(using the staff ID Number) the form with the staff's Name, Team. Supervisor, Current Leave Balance, Sick Leave Balance and Comp leave Balance. However, it also pulls every leave request they have made in the seperate section which will be used to submit to the database their leave Request using fields from another table.
2. If I attempt to use the Secondary Database to submit data, I can't select a Database (only Web , SharePoint, or e-mail).
3. If I attempt to select the Leave Request and have the Leave Balalance Query as a child, the Submit is canceled (denied) because the Query is too Complicated.
I'm snookered everyway I turn, Please if someone could please point me in the right direction. We need something soon. Thanks