I am working on a sequential workflow in VS2008 that needs to determine approvers based on the total expense field entered in the PO form (Infopath 2007). Right now I have the form set as a browser-based form associated with a document library to kick
off the workflow. The tricky part is the approval logic needs to pull approvers from SQL server 2008 tables and I am struggling with best approach---should this be a separate task form and module that uses the submitted data (classes formed from
an init form)? If so, are there any examples out there using SQL-based queries on HR hierarchy data to work from?
View Complete Post