InfoPath Dev

Clay, Regarding my padding issue...If I use the following code as my filter....@RELM_NME[concat(txt_RelmNumber, "  ")] I get the first value of the recordset. If I change it to @RELM_NME[concat(txt_RelmNumber, "  ")= @RELM_ID]   it returns nothing. Can you see what I am missing? Thanks Ed

Clay, Still having the issue where 3 and 4 character ID's are not being found unless I hit the spacebar after input into the textbox. I have included my rule and condition for a 3 character account ID entered into the form.  Condition: txt_RelmNumber matches pattern Custom Pattern: AAA Action: field:   ...

Clay, The condition for my rule is...txt_RelmNumber (text box field) does not match custom pattern: AAAAA The action is....txt_RelmName = @RELM_ID[concat(txt_RelmNumber, "  ")= @RELM_ID] Where....txt_RelmName is the value that the rule set's (on the form)   @RELM_ID and @RELM_NME are values from the underlying ...

Clay, Regarding my 5 position character field (Account Number field) that can be combinations of numbers and alpha of 3-4-5 characters in length. For example AAYOS, API, 600, HYUF are typical looking account ID's. As I mentioned, if the value entered in by the user is API, I need to add 2 blank spaces for the lookup to work. I think I need ...

xdXDocument:GetDOM("RELM_LOOKUP")/dfs:myFields/dfs:dataFields/d:RELM_LOOKUP/@RELM_NME[concat(txt_RelmNumber, " ") = @RELM_ID] Clay, I set a condition that looks for the field entered does not equal the pattern (5 characters) this should catch anything that is not 5 characters. Then I've included the filter in the above ...

The value can be 5 character alpha, 4 character alpha, 2 alpha 1 numeric, 1 numeric+4 alpha, 3 numeric+2 alpha, 3 numeric....basically any possibility up to 5 characters. Will this work. I am having trouble getting the rule to work.

I think I messed up trying to explain an issue. I have a field in an ACCESS database table that is 5 characters. Not all records contain 5 characters, some contain 4.  When someone enters an AccountID containing 4 characters, it does not work, they have to enter a space at the end, So, I don't think the normalize-space function is what I ...

I am trying to get the normalize-space function to work on a text box. I've enclose my code, any ideas?    function trimIt() {       var txt_RelmNumberField = XDocument.DOM.selectSingleNode("//my:txt_RelmNumber");      txt_RelmNumberField.text = ...

Clay, Lookups are working, finally figured it all out. Only 1 strange behavior to ask.. When the user enters an account ID into the textbox, if the account ID entered is less than the field size of the table structure, we have to type in a space at the end of the text box. Do you know how to fix this feature? Thanks Ed

I've been working hard on getting lookups to work, and finally I have done so. I have them working from drop downs and straight text boxes. Our accounts can be full text names like ABRA and they can be 600. My lookups work when I enter the text as in the case of ABRA, but when I try 600, (the rule does not return anything). Can anyone shed ...