InfoPath Dev

CLAY...   I GOT IT TO WORK. I WANT TO DOCUMENT WHAT I HAVE DONE AND THEN I WILL LET YOU KNOW. THANKS FOR YOUR PATIENCE AND HELP. ED

Clay, What you described I actually got to work, but its not what I am really looking for. I have two fields RELM ID: and RELM NAME (Account ID and Account Name),   I want to select the RELM ID value from the drop down listbox (which works) and have the RELM NAME pop into the RELM NAME test box. I'm getting the value ...

I tried using a dropdown listbox and set its data connection properties to the secondary data source (which is a 2 field query). Now, I get all the account numbers in the drop down and I want the account name to populate in the account name text box. I tried a rule but I get the first value of the account name field of the query...So, I know ...

To All... Hopefully you can clear up some confusion regarding designing a new Infopath form with a database connection. It seems if you don't include all your data fields in the beginning, you are out of luck if you need to add something at a later time. (IE secondary data connections). In my case, someone built the form (with no data ...

Hi Patrick, I'm pretty new to Infopath...how do you copy the data into the main data source? And if I had to write code, what language? I am pulling my secondary data from an Access query. Where can I find examples of the type of code I would need to write..   Thanks Ed

Clay, One thing I neglected to mention is the underlying query is a secondary data source. I noticed in the help system on the filter that  it says ... Note  You can only filter data from a primary data source. Because you cannot filter data from a secondary data source, the Display tab for a control connected to a ...

Hi Clay... Thanks for your help. I am trying your suggestion regarding the rule. However its not returning the value. I enter the account number in the account number field but nothing populates in the name field after I press enter, DO I NEED A QUERY BUTTON. I set up the rule exactly as you wrote previously.....  I put the rule on the ...

Hi Thanks for your response. Is there an example of this in a book or somewhere. Can you recommend a book that has examples. Thanks

I have an existing form where the users enter the account number and name into two text boxes. They want to enter the account name in a text box and have Infopath lookup the account name. I have the query built (in access) that returns this info,  but how would I implement this in the existing form. What would I have to change. I know I ...

Clay, The file they are accessing (which I am getting the security message) is an .xsn . I cannot find the XML file....Does that make sense? Is it possible he set up some kind of security on the xsn file .....