InfoPath Dev

Hi, another thing I just noticed is that your one of your tables does not have a primary key, this prevents submission. Fix this and you can query and submit. Happy Halloween

Hi Sorry, shjould have welcomed you to the forums! OK, I think the issue you are having due to the query being run again on submit and the form getting confused.  That is why it is better to have it on a button so that it doesn't re-run. To store the result you would need a field in the first database to act as the sum of the hours in ...

Cool Let me know how it goes. One other thing, as these users do not have Outlook, do they have Infopath installed? Cheers

Hi No code, just make the fields the same but the controls different I hope this makes it clear Cheers

Hi I have not treid this personally but it would be possile in managed code.  I googled the question to find the following: Sending Email From InfoPath Using Managed Code It is possible to send an email from InfoPath when a form is submitted. Just add a new data connection and select "Email message" as your data submission ...

OK Easiest way to do this, I think is to have the two tables related by a common field in the same database.  Then change the drop-down list to be a queryfield bound to the same field and add a query button to pull back the records in the tables that match the customer in the querfield. To sum the hours you need a field ABOVE the repeating ...

Hi I think you can solve this by going into form options and then go into Tools/Form Options/Advanced in 2003 and set the drop-down to automatically update, or Tools/Form Options/Versioning in 2007 then do not tick the tick box  and that should work fine. Cheers

Hi Well, to answer your question, I don't think so.  How many are we talking about? Cheers

Hi First off I am not a coder so I can't help you translate your code.  On the bright side you can use the link below to find all about the object model in InfoPath 2003. http://msdn2.microsoft.com/en-us/library/aa947605(VS.80).aspx I hope this helps

Brilliant Thank you Jim and all.  Think I should go out and buy a Win 2003 server to MAKE it work.... Maybe I could claim it on expenses! Thanks again Adam