https://www.infopathdev.com:443/forums/44.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/53128.aspxFri, 26 Mar 2010 03:56:23 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:53128Patrick Halstead0https://www.infopathdev.com:443/forums/thread/53128.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=53128<p>Hi UdayaHerath and welcome!</p> <p>If you have a Web Service on top of your Oracle DB it should be easy. Do you know if you have a Web Service or not?</p> <p>&nbsp;</p>https://www.infopathdev.com:443/forums/thread/53095.aspxThu, 25 Mar 2010 04:09:34 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:53095UdayaHerath0https://www.infopathdev.com:443/forums/thread/53095.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=53095<p>In my scenario I have a Oracle database. I need to fetch data from a table and need to populate in a drop down list.And the other thing is I have a three tables which have one to many relationship and I need to cascade the drop down lists.</p><p>Its like this I have three tables as follows.</p><p>&nbsp;I have company table. Company has one or more Branches. One branch has one or many employees. </p><p><img src="https://sites.google.com/site/udayashantha/relation.bmp?attredirects=0" width="515" align="middle" height="65" alt="" />&nbsp;<br /></p><p>I have created a view in Info path. I created one drop down in it and it should consists name of companies. When user select one company second drop down should populate data only related to the the particular customer. When one branch is select the third drop down should populated the employees only for that branch.</p><p>&nbsp;</p><p>Can anybody give an idea to implement this. </p><p>Thanks </p><p>Note: I am new to the Info path. I just started work on Info path.<br /></p><p><span></span><br /></p>