https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/121110.aspxFri, 07 Jun 2019 18:36:23 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121110Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/121110.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121110This link has a few screenshots that may be helpful: http://www.ntss.eu/infopath-2013-populating-a-data-field-based-on-another-field-i-e-external-connection-2/https://www.infopathdev.com:443/forums/thread/121109.aspxFri, 07 Jun 2019 18:04:28 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121109jordanberry890https://www.infopathdev.com:443/forums/thread/121109.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121109I think I may have see what was wrong. It was my fault. I had the default value for the value field being just #Items and Unit Price. So what I did it made it so whenever #Items is changed, it sets Value to your foruma * #items, and that seemed to work out great. Thank you so much for all your help! Is there a good resource that I can look at so I can figure out the formula you wrote?https://www.infopathdev.com:443/forums/thread/121108.aspxFri, 07 Jun 2019 17:59:32 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121108Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/121108.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121108I wonder if part of the problem is that the Unit Price field is a choice type. Maybe change that to number?https://www.infopathdev.com:443/forums/thread/121107.aspxFri, 07 Jun 2019 17:48:27 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121107jordanberry890https://www.infopathdev.com:443/forums/thread/121107.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121107Alright, so that gets the correct value, so thank you very much! This may have opened up another can of worms though. Now when I publish it to Sharepoint, and try to add a new item, it throws the error show in the pic below. I added number(your formula) to the properties of the unit price box, but that didn't help it. Any ideas there? After clicking Submit -> error Ok, Value becoming NAN. Value is just (Unit Price * #Items)https://www.infopathdev.com:443/forums/thread/121105.aspxFri, 07 Jun 2019 17:37:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121105jordanberry890https://www.infopathdev.com:443/forums/thread/121105.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121105Scratch that, google fixed that one. Should have searched before I asked here! I am opening it and seeing it is working out. Thank you for all your help so farhttps://www.infopathdev.com:443/forums/thread/121104.aspxFri, 07 Jun 2019 17:33:15 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121104jordanberry890https://www.infopathdev.com:443/forums/thread/121104.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121104Unfortunately I can't open it. It seems like its looking for your path, since its trying to reach out to a server. (pic attached)https://www.infopathdev.com:443/forums/thread/121103.aspxFri, 07 Jun 2019 17:26:12 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121103Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/121103.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121103I changed the default value for your existing Unit Price field. See if this works as anticipated. Save locally, right click, select design to open in design mode.https://www.infopathdev.com:443/forums/thread/121102.aspxFri, 07 Jun 2019 17:08:23 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121102jordanberry890https://www.infopathdev.com:443/forums/thread/121102.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121102Sure. In this form, the items I am looking at the Product drop down and Unit Price text field. Please feel free to create new fields, as this more than likely will not be the final form designhttps://www.infopathdev.com:443/forums/thread/121101.aspxFri, 07 Jun 2019 17:05:56 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121101Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/121101.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121101Here's a sample. Set Value Sample view has a dropdown with a rule on it you can take a look at. Save the form locally, right click and select Design to open in design mode, then you can preview.https://www.infopathdev.com:443/forums/thread/121099.aspxFri, 07 Jun 2019 16:58:21 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121099Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/121099.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121099We add a filter when we select the table row to get back just the selected one... Do you mind attaching your form? I can set this up for you so you can see it.https://www.infopathdev.com:443/forums/thread/121097.aspxFri, 07 Jun 2019 16:00:05 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121097jordanberry890https://www.infopathdev.com:443/forums/thread/121097.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121097Wow, thank you for the quick response! I do need a bit of help if you don't mind. So you are saying set Value and Display to Product. But then how would I get the rule to look at the price associated to that product in the table? ( I am extremely new to this, so I am sorry if I require a bit more hand holding)https://www.infopathdev.com:443/forums/thread/121096.aspxFri, 07 Jun 2019 15:35:13 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121096Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/121096.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121096Sorry about the formatting issues - the forum software is old - use IE for best experience (even though I don't, I just gave up on line breaks & use Chrome). I think you should set the dropdown to use the name for the display and value and add a rule to the product field that sets another field to the price. Let me know if you need a hand with that - you can attach a copy of your form under Options in a reply.https://www.infopathdev.com:443/forums/thread/121095.aspxFri, 07 Jun 2019 15:30:20 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121095jordanberry890https://www.infopathdev.com:443/forums/thread/121095.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121095Sorry for the terrible formatting, not sure why new lines are not coming inhttps://www.infopathdev.com:443/forums/thread/121094.aspxFri, 07 Jun 2019 15:28:15 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121094jordanberry890https://www.infopathdev.com:443/forums/thread/121094.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121094I feel like I have looked everywhere for this answer, but cant seem to get it work how I like. Here is my situation. I have a sharepoint list that looks like this ID | Product | Price 1 | Item | 100 2 | Item2 | 300 Infopath has 2 fields (in this scenario): Product (Drop down list) Price (Read Only Text) I then have an infopath form reading from that table. What I would like to happen is, the user selects the product from a drop down list, and the unit price is shown in a read-only text field. Here is what I have tried, but ran into issues For the drop down, set the display to Product and the value to Price, then set the default value of the Price field to Product, which brings back the value (not display). This is exactly what I want, except when I publish this to a sharepoint site, and save it, the form will create a list entry with ID | Price | Price, and never set the display name.