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/10249.aspxThu, 10 Aug 2006 11:15:38 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:10249Millie0https://www.infopathdev.com:443/forums/thread/10249.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=10249I think I circled in my Problem. I need to fil lout automatically some fields depending from a value the user can select in a combobox.<br />To do this I added the two tables MACHINES and ADRESSES to my primary connection. Well then Infopath writes also in these tables: This causes my problems. I removed the tables from my primary con. and the adding worked. But now I fail in filling out the fields cause the tables are missing.<br />Now I hope that theres another way to fill out the fields without the two tables in my primary con.<br /><br />Ideas?<br />Milliehttps://www.infopathdev.com:443/forums/thread/10248.aspxThu, 10 Aug 2006 10:07:49 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:10248Millie0https://www.infopathdev.com:443/forums/thread/10248.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=10248Hi<br />now I removed the ADRESSES table from my primary connection, and now I can write ONE dataset into the MAIN table.<br />If I want to write more than one datasets I get an error message that a empty line can´t be written.<br /><br />I am really confused.<br /><br />Milliehttps://www.infopathdev.com:443/forums/thread/5769.aspxThu, 10 Aug 2006 09:17:48 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:5769Millie0https://www.infopathdev.com:443/forums/thread/5769.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=5769Hi<br />as you may have noticed I am developing a formular.<br />In this form the user can insert new datasets. This worked really well, until I expanded may primary connection to another table, adresses.<br />My structure is now:<br /><br />MAIN table--<br /> |<br /> table MACHINES--<br /> |<br /> table ADRESSES<br /><br />I actually write only into MAIN table. Since I have added the ADRESSES I can´t write any dataset, he tells me that "the value for the identity column can´t be set as long as IDENTITY_INSERT is set off" The point is I musn´t write anything into ADRESSES.<br /><br />Since I have added the ADRESSES table I also get two times the security warning when opening the form.<br /><br />I´m really desperate now, cause everything was so fine and now it seems to become a real problem!!!<br /><br />Can anyone help me??<br /><br />Thanks<br />Millie<br />