InfoPath Dev

hi,

 i want to use the absence request template form and connect the employee section and manager section to an existing database.

what i want to create now in this template is this (i'm going to explain my scenario):

- when the user open the infopath absence request form and insert his name, id number etc (employee section), the approver's name and mail addres (manager section) filled automatically. the approver name must be corresponding to the user name. in the existing database there is a table with the approvers name filled for each user, but from there i dont know how to apllicate this table to use for the auto fill.

and after the form is ready can i publish it to my wss 3 site collection?

is there a tutorial that explain a scenario like this?

thnx

Hi Jenfi,

This is really easy to do. Some tutorials cover pieces of it. For example, Qdabra's Active Directory Web Service comes with a bunch of documentation for setting up a form to query user name of the logged in user. To query your database, you can install the free trial of Qdabra's Database Accelerator which includes the active directory piece and also allows querying a database in very little time. Both come with extensive documentation.

We have an off-the-shelf Absence Request InfoPath solution that we have developed for companies over the years. We'd be happy to show it to you. It would have to be modified to pull data from your specific database, but we could do that quickly and deploy the form to your WSS 3 site. No SharePoint required too so it doesn't have to be WSS.

Send me email if you want a demo.