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/2323.aspxWed, 10 May 2006 09:42:14 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:2323Raoul0https://www.infopathdev.com:443/forums/thread/2323.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=2323Hi Matt,<br />thank you for reply. My final idea is to realize 3 forms (on 3 views), each one for an mdb tab (form1 for tab1, form2 for tab2, form3 for tab3). Tab1 have a one2one relationship with tab2 and tab3 (for means of ID field). I need to enter Id on form1 (view1), then all other forms that I select (views) come up with all fields already enlivened with tabs value, without I can enter ID on its. Besides I need to modify values in fields and send new values (update) to table.<br />I am sorry for my "bad" english.<br />Thank you for your help.<br />Raoulhttps://www.infopathdev.com:443/forums/thread/2322.aspxSat, 06 May 2006 01:58:30 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:2322Matt Faus0https://www.infopathdev.com:443/forums/thread/2322.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=2322Hello Raoul and welcome to the forum!<br /><br />Can you provide a little more context on what you are doing? One helpful piece of information would be how your form is laid out. Does it use repeating tables? And how are you running the query?<br /><br />Sorry if this isn't much help, I'm just trying to understand the problem a little better.https://www.infopathdev.com:443/forums/thread/1280.aspxFri, 05 May 2006 13:32:59 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:1280Raoul0https://www.infopathdev.com:443/forums/thread/1280.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=1280I have 2 MDB tables as follow:<br />- TAB1<br /> - ID numeric (primary key) <br /> - NAME1 text<br /> - NAME2 text<br />- TAB2<br /> - ID numeric (primary key) <br /> - NAME3 text<br /> - NAME4 text<br />Tab1 and Tab2 (ID) one to one relationship.<br />On single form I have a query that search in TAB1 for ID and/or NAME1, and as answer fields I have NAME1, NAME2, NAME3 and NAME4 from both tables. My problem is that NAME1 and NAME2 return right value from query, but NAME3 and NAME4 fields return no value.<br />Can you help me?<br />Thanks. Raoul