InfoPath Dev

Patrick, if your questions help speed up our connection, ask as many as you'd like. The Main Data Source is a SQL Server Database Connection.  Right now, there are 2 tables in the main database connection.  PurchaseOrders and indented and linked underneath is "POItems".  When we remove the POITEMS table from the Main ...

Patrick,  Thanks for the well thought out reply.  The sql query is very quick.  There is always one header record retrieved and probably on average 5 line items.  There are many columns of data returned, but few number of rows. The xml form is only 35K.  Where can I get pricing on your webservice? One thing we did ...

We have a Requisition Form used at all facilities on our WAN. The main dataconnection is SQL Server DB Tables called PurchaseOrders and a POItems.  The POITems is a repeating child table under the PurchaseOrders.  PurchaseOrderID is an identify Field and is the forgein key in POITEMS.  Make sense?  e.g. 1 to many ...

Please point me to articles, threads or best practices.  I haven't found quite what I'm looking for.  We have a repeating table that is populated with data from a secondary webservice dataconnection.  item #, Unit Price, Qty, Extended Price. This table can have any number of rows.  The webservice retrieves and ...

We have 2-3 domain controllers active in our organization.  Can we force the GetMyUserInfo to access a specific DC.  When we involked the call it was taking 15-20 seconds to return.  One of our theories is that the call was was accessing our DC in the Texas facility which has a slow connection to corporate.

I have a 1 table db where I'm storing username and password and other fields. I have the user selecting their username from a dropdown list first before typing in the password (Dropdown list is populated from another list).  Here is my logic problem: 1:  I first run a rule to query by username.  If the user does NOT exist, I ...

I accidently posted this to the ''Newbie'' forum. Here it is again. We have a Purchase Order we are printing. The Signature Section ALWAYS need to be on the bottom 2 inches of the form. Problem. The line items on the PO are a repeating table for obvious reasons. When you add more lines to the PO, the ''Signature Section'' gets pushed to a ...

What do you mean by ''Don't forget the & inside the quotes?'' I cannot get this to work, but your message implies something else has to be added. Disreard the question. We figured it out. We needed an ''&'' in front of each encoded string. i.e. crlf=''#xD;#xA;'' needed ''#xD;#xA;'' quote:Originally posted by lxhiss Guys, Don't forget the ...

Matt, I am trying to get the filename in my Infopath form for a file that is contained in a SharePoint ''Document Library'', and not a form library. I do see the ''Title'' as you described, but unfortunatley, SharePoint is not putting the filename in the ''Title'' field. SharePoint is using the ''Name'' property to store the filename in a ...

I have a form from which I want to place a hyperlink to a document from a SharePoint Document Library. I created a data connection to the SharePoint Document Library - Works However, the field I need from the Sharepoint library is the ''Name'' field because it is the actual filename in SharePoint. I see all other SharePoitn Meta Tags such as ...