InfoPath Dev

I want to perform an SQL look up on a large catelogue table help on an SQL Server and populate a repeating table.

I've managed to use Query fields to populate datafields in my table, but each time I create a new row inthe table and repeat the query, the existing entry is cleared.

How can i peroform a row by row query on this table and populate the remainding fields in each row based on the criteria set in the query?

Hi Taffman,

I'm not sure that I understand your exact scenario, but I think you could gain something from reading these HowTos:

http://infopathdev.com/howto/tutorials/default.aspx?s=Master/Detail

If I'm completely off, just reply back with a little bit of clarification so we can get your stuff working!

Did you rerun the query or have you added a submit button