InfoPath Dev

Hi all,

I have an InfoPath form which has for example two fields. One is a drop down with 4 names and other is a field for their e-mail ID.

Name:
abc
def
ghi
jkl

If I chose abc in the name field, my email field should be populated as abc@mycompany.com and if I chose def, then it should be populated as def@mycompany.com and so on....

Is this possible and if yes, how? Do I need to have a drop down list for the email ID also, or is it enough to have a text field?

Your help is highly appreciated and millions of thanks in advance.

Regards
Subramanian

Hi ragav_in

Yes it is possible and text box is enough for displaying email ID

You follow the steps given below.
1. Right click on Dropdown list box and select “Drop Down List Box Properties”.
2. Click on “Rules” button Rules dialog box is opened, now click on “Add” button.
3. Click on “Add action” in “Rule” dialog box.
4. In “Action” dialog box select “Action” field as “set a field#%92s value”, In “Filed” filed select “Text box” filed in which email is to be displayed.
5. In “Value” field insert “concat” function as concat (TextFiled,”@mycompany.com”)

 

Hi
this is what i want to do with my form but one issue. I do not have the rules button described.

I have a drop down that is populated with data (names) from an access database.

What i need to do it when i select a name (teachers name) I need  text fields to show what make/model and serial number of their laptop they have.
The other data fields are in the same table as the teacher names.
Have info path 2003, would have thought from the date on the post that the suggestion would also have been for infopath 2003

 Can anyone help?
Thank you
Peter

Thunder, how have you tried to do it so far?  You should be able to make your data connection to Access and pull in that data.  Then, on your dropdown that shows teacher names, you can add Rules that set field values in the other fields to the proper data type with a filter saying "where AccessName = InfoPathName".  What I mean is that your dropdown control in InfoPath will be based off a text field you add to your main data source.  That is the "InfoPathName" from the equation.  The AccessName would be the Name node from the secondary data connection.

Hi warrtalon

I fixed the rulles button issue by installing Office SP1
I have tried to do this based on this guide http://www.academictutorials.com/ms-infopath/ms-infopath-listbox.asp

I must be doing something wrong as it just does not want to work
What i need is from a drop down i choose the last name of the teacher and it will populate 4 other fields with first name, laptop serial number, laptop make, laptop model.
This is an laptop audit form i am making to tie in with my asset register i use for the computers.
I have attached screenshots of the form and the database and highlighted the firlds in the database i want to be displayed.

I can also attach the form and the datasbe is a MS one from teh office site
http://office.microsoft.com/en-us/templates/TC010184591033.aspx

 

Here is the form screenshot as i can only have 1 at a time :)

 Thank you

Peter

Hi Me again

I have it at the point where it will show lastnames in the drop down but i can not get it to populate the other fields
Just thought i would add that to show that i have it connecting to the databse. They actually need to display data from 2 different tables. One is an asset table the other is the employees table but the are linked via the asset i think

 Peter

Ok, I do this sort of thing a lot, but I haven't done it with Access as my source of data.  In your data connection to Access, are you connecting to the MDB itself or to individual tables?  If it's to individual tables, then do you have 2 separate connections - one for each table that has data?  If it only connects straight to the MDB, then are you able to specify tables when retrieving data?

Now, if the value you're using for the dropdown (value, not display name) a primary/unique key across the tables, then you should be able to populate these other fields in the form by matching the value chosen in the dropdown with that same value in the tables.