https://www.infopathdev.com:443/forums/46.aspx For questions concerning issues in the integration of SharePoint and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/16404.aspxWed, 13 Sep 2006 23:33:20 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16404Matt Faus0https://www.infopathdev.com:443/forums/thread/16404.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=16404The easiest way I could think of to solve this problem is as follows:<br /><br />1) Promote the total hours worked per timesheet into the form library.<br />2) In the timesheet form, establish a connection to this form library.<br />3) Perform calculations to add all of the previous hours together (from the promoted properties), and then in the form display how many hours are remaining.<br /><br />The main problem here would be storing the total hours available (400 in this case) - I guess you could use a SharePoint list or some other configuration method.https://www.infopathdev.com:443/forums/thread/15465.aspxWed, 13 Sep 2006 19:24:48 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:15465Methtical0https://www.infopathdev.com:443/forums/thread/15465.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=15465I have a consultant time sheet I am working on. It is housed in a sharepoint site with the "My Forms" view so they can only see thier own. After each daily entry, the total hours are calculated. That part works fine. <br /><br />The problem is, there will be a new time sheet submitted every two weeks. Therefore, a totally differnt xml file will be created. I need to have a box that displays the total hours the consultant is contracted for, updated each time. For example, Joe Shmo is contracted for 400 hours. He worked 80 hours the first two weeks. He is now ready to start a fresh time sheet. That sheet needs to autmatically display 320 to reflect previous time sheets submitted.<br /><br />How can I do this?<br /><br />Thank you.