Hi everyone.
I have a form based on a MS Access database over the network.
I have a table with support information for commercial quotations.
this information are kept with the same numeric sequence that the quotations.
When I'm filling a quotation, infopath looks at this table and conditionally only shows the lines with the same number as the quotation. since is load descending the information is always on top of the table and no one knows that the table is longer.
the problem is that with the increase number of quotations the size of the email sent is increasing due to the fact (i think) that all the table is being loaded and sent to the client.
Is there a possibility to send only the needed information based on a query?
all tables are loaded at startup.
Thank!
PS . I'm a newbie user without programming capabilities.