InfoPath Dev

I was hoping someone could point me in the right direction. I have created a sharepoint list that the agency uses as a purchase order request and log.  At the end of each month I am required to reconcile the purchases to the statement received from the credit card company. There are a couple of things that need to happen during this ...

I'm sure this has been answered before, but I guess my search isn't giving me what I need to know. Is there a method that exists in DBXL that allows a form to retrieve data from existing SQL tables, then conversely update the data if it changes?  For example, we have a SQL table of existing IT employees with various personal data ...

I have a field on the form that is prefilled with prefix characters based upon a choice field elsewhere in the form. The requester is to enter in subsequent characters however we do not want them to overwrite the prefix characters. How can I block the prefix characters? I also would like to ensure that the field must contain 5 or more characters ...

Individually the rule works on each column, but once I start clicking on other columns then the behavior gets wacky.  I've tried changing the order of the rules, but no luck.

 I put the error field on the form and I didn't get any errors.

 All, I have an interesting requirement. I have a form where the submitter picks his manager user a People Picker field. My requirement is that Managers can only see their own and cannot see other forms with other managers. How do I create a view to meet those requirements in a webpart?

 Great - can you also include info on what error you are getting when you try Insert or Delete after your initial delete? Your doc says: ...the insert command and the delete command no longer works. But I'm guessing you may be getting an error in the Qdabra Rules error node?

 If the user changes a field in any of the drop down columns each will be inserted/updated into the main data source repeating table.  If the user changes any of the fields back to it's original state (all columns are the same as they were when search results were first returned) that row needs to be deleted.  I'm going to ...

 Like I said before, I'm still having trouble understanding what row you are trying to delete. At any rate, the /xpath parameter for your delete command needs to be the XPath to the repeating element(s) you want to delete. Are you trying to delete the last instance of a row that matches the ID of the row your are currently in? I'm ...

 This is the code that worked for me concat("Delete /xpath=my:myFields/my:BPResults/my:BPSubmit[my:ID = '", ID, "']") but it only works one column at a time.  If I change more than one column my inserts stop working and the delete no longer works.  I'm sure I need to get the current ID to get the ...