InfoPath Dev

I agree, so where do I go to find the code that I need to put into my form?  Is there another forum that talks about code?  Can you suggest a book?  Any help would be appreciated.  Thanks

Let me see is this picture helps.  I have my data source rearranged so that AdministrativeSrervices has all the sub titles under it.  AdminSuite, Education, Employee Services AdministrativeServices AdminSuite Education EmployeeServices InfoServicess LobbyServices MedicalRecords Under the Summary Page, I need a repeating table to look up ...

I'm not having much success with this, I will try again tomorrow.  I bought a book Pro Infopath 2007 by Apress.  It seems to be very generic.  I can't figure out how to Summarize my data on the main summary sheet.  I just want it to give me the sheet name then input the totals for that sheet, maybe I should try it with ...

I rearranged my data source and my fields into how it might need to be structured.  Is it possible to autopopulate a repeating table with data using a function?  For instanct here is my layout:  TOC_Summary [group] Services [group] repeating Sheet [Field] Total [Field]Admin Services [Group]AdminSuite [Group] Header ...

I can get the pulldown list to show Acute Care A and Acute Care B, on the Summary Page, there is a rule that I setup to automatically fill in the Total on the Summary page from the other forms, when I choose Acute Care A "611" is the correct total that is automatically filled in on the Summary page, when I select the Acute Care B I get ...

 I am also trying to get the drop down list to remove the item once it is selected.  For instance, once I pick Acute Room A it does not appear on the drop down anymore. 

 Here is the example file. 

 Here is the second repeating section of the form.

 Here is the filled out forms from which the data is coming from.

I'm on to the next step of my form and I realized that now I need to take all the information that the user inputs in the repeating sections into a Summary Sheet.   I will post an example of my code and some images of what is going on.  I am able to get a pulldown to show the Sheet Names for each section, and it pulls in the data for ...