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/3192.aspxThu, 21 Sep 2006 07:17:54 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:3192Patrick Halstead0https://www.infopathdev.com:443/forums/thread/3192.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=3192Hi Dennis,<br />Sorry for the delay in responding. I actually read your post but didn't have time to respond last week and then our web server went down and we had to jump on that. Anyway, glad to see you figured it out! :)https://www.infopathdev.com:443/forums/thread/3191.aspxWed, 20 Sep 2006 06:31:46 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:3191dennis d.0https://www.infopathdev.com:443/forums/thread/3191.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=3191well, i solved it, by just deleting new added items from the database, after using its values.<br />that way i keep the entrys temporary and the db doesn´t get too large.<br /><br />thx neway<br />dennishttps://www.infopathdev.com:443/forums/thread/1559.aspxFri, 15 Sep 2006 11:42:12 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:1559dennis d.0https://www.infopathdev.com:443/forums/thread/1559.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=1559okay i have a form that has a repeating table in it.<br />within the rep.table i have dropdowns (with selections excluding each other i.e. i select personA in dropdown 1, then i can´t select him in any following dropdown).<br />i have a "submit" button that saves the selected persons to a database in their own row.<br /><br />now the problem:<br /><br />i need to add an ID-value to the database.<br />but the value shall only be added to the selected persons, and to all of them.<br /><br />okay for better understanding here the database-style:<br /><br />before selection:<br /><br />name------email------temp------ID<br />personA---Amail-------------------<br />personB---Bmail-------------------<br />personC---Cmail-------------------<br /><br /><br />after selection (personB and then personA) and submit:<br /><br />name------email------temp------ID<br />personA---Amail-------------------<br />personB---Bmail-------------------<br />personC---Cmail-------------------<br />-------------------personB--------<br />-------------------personA--------<br /><br /><br /><br />what i need now is anything that does this:<br /><br />name------email------temp------ID<br />personA---Amail-------------------<br />personB---Bmail-------------------<br />personC---Cmail-------------------<br />-------------------personB-----ID B<br />-------------------personA-----ID A<br /><br />i need this data, because another form uses this database to get selection alternatives given by preselected data.<br />(i.e. in form 2 i can only choose from data, that were already selected in form 1 - kinda validation method)<br /><br />i don´t mind if the ID is added while selecting B and A, or afterwarts, per buttonclick or something.<br /><br />the problem is, that i need to add a specific id to the chosen names, because they could be chosen again days later.<br /><br />so: how can i add data in my database depending on selections made in my form, and add that data to a specific row in the database, that belong to the selected items before.<br /><br /><br />and while i´m already posting:<br />how can i delete specific data from my database per buttonclick?<br /><br /><br /><br />thx<br />regards<br />dennis