InfoPath Dev

Hi ,

I have a requirments to

1- create an infopath form which has repeating table , date , textbox , richtext box - display some values from SQL DB ( primavera ) -into drop down list

2- save its  into sharepoint Form library and make the values avilable in the library ( columns )

3- approval workflow in the form

4- once the infopath form is approved and saved in the form library ...  store the values of the form inside SQL DB ( so it can be used in Crystal reports )

how can i accomplish the tasks in Bold of displaying values from SQL and adding infopath values into SQL ( especially repeating table how to vetch the values  )

SQL integration with InfoPath is usually done by using a web service. You can try Qdabra's DBXL Accelerator for free - there is a web method called QueryDB which allows you to filter data retrieved from SQL that you can then use in a dropdown list. It comes with an admin tool where you specify the mapping to be able to submit data from your InfoPath form to SQL.