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/8685.aspxThu, 05 Jan 2006 13:11:30 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:8685Flurry0https://www.infopathdev.com:443/forums/thread/8685.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=8685Thanks...that might work...I'll give it a try a little later today...<br /><br />I have been playing with the master detail relation in infopath and have another problem. I create a form with a database conection involving two tables with a master/detail relationship between them. What I'd like to do is query the database based upon the master table and return the detail table entries. This works fine when I add the master fields to the query section and the detail fields to the data section.<br /><br />However, when I try to add a new record to the detail section, I get the following error:<br /><br />'[0x80004005][Microsoft Cursor Engine] Empty row cannot be inserted. Row must have at least one column value set'<br /><br />I was wondering if anyone can explain this to me or give me some clues as to what is going on???<br /> <br />I'd appreciate some help as I'm new to infopath and am struggling to work with master/detail relationships.<br /><br />Cheers...https://www.infopathdev.com:443/forums/thread/8684.aspxWed, 04 Jan 2006 17:01:59 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:8684Matt Faus0https://www.infopathdev.com:443/forums/thread/8684.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=8684How about a repeating table with only one column? You could add as many different data fields into this one column and it would behave very similiar to a repeating section.<br /><br />---------------<br />Matt Faus<br />InfoPath Dev Texas<br />https://www.infopathdev.com:443/forums/thread/5241.aspxWed, 04 Jan 2006 15:06:31 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:5241Flurry0https://www.infopathdev.com:443/forums/thread/5241.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=5241Hello<br /><br />I'm new to infopath and have been trying to figure out the master detail control. The thing is that when I add my fields to the form and select master/detail for them, the master fields are represented as a repeating table. What I'd like is to have the master fields represented as a repeating section with controls and the detail fields represented as a repeating table. This is possible in Access forms but doesn't appear to be possible with infopath.<br /><br />Could someone please confirm this and let me know is there a better way to represent master/detail relationships on infopath forms.<br /><br />Regards...<br /><br />John