InfoPath Dev

 Whatever values you required put try to merge them in one table, So that you will require one data connection and also while creating data connection check only those column which you require. Because no. of data connection , no. of rules at Open & Save , Rich text control hampers the performance.

 I already tried that, but still slow. For example, if I capture a receipt, I query the main source for the Item ID, and using rules and conditional formatting the form displays information from the secondary sources about that item (for example Open Purchase orders, can not capture a receipt with no open orders), after the form is submitted, the secondary source changes (open orders changed for that item), and need to re-query the secondary source after form submission.

The actual process, once the form is open, is:

1. Enter Item ID
2. Query main source
3. With rules or conditional formatting, show information from secondary sources related to item ID
4. Enter information
5. Submit form
6. Re-query secondary sources that changed
7. Enter a new Item ID and repeat the process

I think it would be faster if the process is:

1. Enter Item ID
2. Query main source and secondary sources for only that item (no the complete tables)
3. Enter information
4. Submit form
5. Enter a new Item ID and repeat the process.

With this process there are fewer records to retrieve from access, less rules, less conditional formatting. Is it possible?

 Thanks

Hi,

Why dont you use managed code for this, this will be easier and faster in managed code.

Hi 

I want to use code, but I don't have any idea of how to code.

I am new with InfoPath,  I even didn't know that there was an application called InfoPath three months ago. Took me lots of time and searching to learn how to make the forms.

When I search for something that can help me to do this, I just can find the answer: "It can not be done without code", but I can not find sample code that I can adapt. The only coding experience I have is with VBA in Excel.