InfoPath Dev

All,  I need to do a client name and or a company name lookup.  The data is already held within an sql db. I'm v.new with SQL. On my sql box I can get my sql person to design a stored procedure so that it can return a list of client names and or company names. How do I connect my infopath form to the stored procedure ...

I assume you're using InfoPath and SharePoint 2010. I assume a button or something updates a field called Form Stage. Publish your InfoPath form and promote your required columns i.e. Form Stage. If you haven't already create an "Admin view", so that if required you can change/alter the Form Stage field. - ...

All, Is it possible to use a people picker to select multiple people. The selected people are then used to set permission on a published form in a SharePoint library? I've a form with multiple people pickers. I'd like these selected people to be the only ones to view,edit the form etc., but not other forms in a SharePoint ...

 You could try something similar to this:  http://www.infopathdev.com/forums/p/25601/88891.aspx#88891

Not sure if you can do it from a button. That would be your department :) I've used a workflow to easily update  Word documents with data from Infopath Forms. You might want to look at SharePoint content types, promoting InfoPath columns and using Quick Parts in Word.  

 If I've understood you correctly. I'd have one form. Each "area" you want filled out would be in a section. You would need to put button into their own sections  on your form. Button A when pressed would set field A. You could then use rules to hide buttons and sections as required.

 My initial reaction is how will the form know when the repeating section has finished and complete? You'll always be able to add more sections, so it will always be open and never finished. Thus how about after X set another field to Closed and use that to switch to closed.

 For me it's not the content of the form. It's the constant saving, changing, moving and publishing that I think breaks the design of the form.

 Not sure if it's possible with an external data source, yet is your drop list format the same i.e. productname - number KG. if so you might be able to use an inbuilt substring function to extract the number. Then it would be a question of doing the math on that number. Might have to play around so that the extracted item is recognised as ...

 If you connect to your SharePoint List List Tools>List>Customize Form.  You can use the list new item box as a "template". Also how are you adding items to the list without the form? Add new item at the bottom of your list? - then the above may be your best bet. Otherwise the look and feel of the Infopath form could be ...