https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/9491.aspxThu, 13 Apr 2006 05:05:07 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:9491SamDahl0https://www.infopathdev.com:443/forums/thread/9491.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=9491Alas, queries are presently beyond me...https://www.infopathdev.com:443/forums/thread/9490.aspxWed, 12 Apr 2006 02:51:01 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:9490sscarcella0https://www.infopathdev.com:443/forums/thread/9490.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=9490I did find an example using the concat function. That did the trick and will do for now. Only problem now is that I want to query the field that has the comma delimited list and because of the , and the space I cant use a simple dropdown for my query selection. Can you think of a rule that will allow for the comma and space? I have a dropdown query field populated from a secondary database table that runs a query of the text field that contains the previous selections that are comma delimited...https://www.infopathdev.com:443/forums/thread/9489.aspxFri, 07 Apr 2006 05:55:43 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:9489SamDahl0https://www.infopathdev.com:443/forums/thread/9489.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=9489One thing you can do is put rules on the DDLs that have no condition and the following acion: concat(yourTextField, ";", .)<br /><br />this is only a crude solution and I imagine you would require something a bit more sophisticated but it's something to start with.<br /><br />Issues with this method:<br />-depending on your rules you may end up with either leading or trailing semi colons.<br />-it doesn't allow for -changes- in the DDL. the new selection is just added on the end of the old.<br /><br />You could solve the first issue by having a seperate rule for if yourTextField is blank.<br />To solve the second issue you may require some code to run a current inventory of selected items and add them to yourTextField. <br />On reflection this is probably what you've been trying to achieve and what I've suggested is therefore of little help to you. <br />With any luck you'll get a response from those in the know.https://www.infopathdev.com:443/forums/thread/5509.aspxThu, 06 Apr 2006 19:48:34 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:5509sscarcella0https://www.infopathdev.com:443/forums/thread/5509.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=5509I am trying to create one field which contains all the selections from a dropdown list that is in a repeating table.<br /><br />When users select an item from the dropdown it gets entered into a field. When users select insert a new item and select from that dropdown that item gets added to the other field separated by some kind of delimiter like a semicolon or something....<br /><br />Anyone know how to do this?