InfoPath Dev

Thanks for the help, This does look a little beyond my abilities but I am more than willing to jump in over my head.  If I ever get it working/figured out I will post back here on my progress. Thansk again.

more or less.  The Rule is on the ID field and is set to set the values of the address boxes.  The issue isn't with auto-filling.  The issue is the Datasource won't load.  There is an error upon trying to access the data source (either upon form open or upon first attempt at accessing) and then the rest of the form ...

Exactly Correct. I am accomplishing the autofilling with a rule on the Site ID Text Box.

They are in a SharePoint List Currently, although we recieved the list as an excel document.

I have an InfoPath form on sharepoint that is reading a list of addresses.  I have it set to autofill the address based on the site code.  The problem is I just got the list of sites and it is 33,000 sites.  This means the browser based form times out trying to load the data source.  The rest of the form still works fine even ...

Thanks, Although this info did not solve my problem it pointed me to the cause.  All our external users don't have any meta data associated with their logins.  I still don't get entirly why I can't pull the user name but there is like no data associated with the users in sharepoint.

Just thinking out loud here, I thought of a messy way in which I would accomplish this (and this is by no means Ideal but I think it will accomplish your goal) -Add a new field in your form called form number - Republish your form making sure that the form number collumn is promoted and that it is editable outside the form. -Set your Document ...

I am building a browser based form in InfoPath 2007 hosted on MOSS.  Our SharePoint implementation has two sides to it the Internal side, and the external customer facing side where our clients can log in and upload docs and colaborate and such.  The problem I am having is in the form I have a section with requestor information.  ...