we have an excel template in place where it does a VLOOKUP on a separate workbook and fills out the remainding columns of the row with product data. I want to replace this excel template with an infopath form (2007), and store it in a sharepoint doc library, however my initial tests have been either confusing or the performance to lookup data from a SQL data source from InfoPath are really slow... like unusably slow.
so I found this on the web, kind of walks through how to do this
The problems when trying to implement this in a test form are:
1. It uses a 'drop down' list, whereas I just want to have a text field that users can input a product number
2. Performance for the number of product records we have is really bad, takes 2-3 minutes and freezes the form, when filling out...
I'm just kind of shocked at how bad the performance was, so I assume either it's just bad filtering on my part, or it will just never be as fast as the excel vlookup function?
I saw somewhat similar posts on EE, and I bought a big thick book on it, but I am just wondering what other people have done in similar circumstances?