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/78080.aspxFri, 27 Apr 2012 16:56:44 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:78080Anson Hidajat0https://www.infopathdev.com:443/forums/thread/78080.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=78080Glad to hear everything worked out :)https://www.infopathdev.com:443/forums/thread/78050.aspxThu, 26 Apr 2012 21:49:46 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:78050Carmine0https://www.infopathdev.com:443/forums/thread/78050.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=78050<p>Thank you Anson your awesome!!! Everything is working fine now!!! </p>https://www.infopathdev.com:443/forums/thread/78044.aspxThu, 26 Apr 2012 18:20:01 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:78044Tom S0https://www.infopathdev.com:443/forums/thread/78044.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=78044I&#39;m fairly new at this myself, but one thing I&#39;ve done is use multiple views-- go to Page Design / New View and you can have two views that look like they are the same page, but one is for Clients and one is for prospect. They can share fields or they can have a separate set of fields for each View. I hope this makes sense.https://www.infopathdev.com:443/forums/thread/78035.aspxThu, 26 Apr 2012 16:08:44 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:78035Anson Hidajat0https://www.infopathdev.com:443/forums/thread/78035.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=78035<p>Hi there,</p><p>What I would recommend is to have two dropdown list boxes on your form that displays data from both tables.&nbsp; Then you want to add formatting rules on each dropdown control such that&nbsp;when the option button value is the other value hide this control.&nbsp; This should give you the behaviour that you want.&nbsp; Hope that helps!</p>https://www.infopathdev.com:443/forums/thread/77987.aspxWed, 25 Apr 2012 19:31:50 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:77987Carmine0https://www.infopathdev.com:443/forums/thread/77987.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=77987<p>Hi! </p><p>&nbsp;I have a project to do for my work and i am stuck right now. </p><p>I have a form that&nbsp;is connected to&nbsp;a&nbsp;Sql table named: Customers</p><p>On my form I have a drop down list box that shows all the name of my customers. When i choose the customer the other text box will auto-populate. </p><p>Everything is working good from here. </p><p>&nbsp;The problem is that we have to use the same form for another table named: Prospect wich will basically do the same thing. </p><p>What I am trying to do right now is&nbsp;to put an&nbsp;Option Button (1. Table:Client&nbsp; and 2.Table:Prospect) and when&nbsp;we select one of them the drop down list box update automatically with the good data.</p><p>&nbsp;I dont know if im clear, but basically&nbsp;I want my drop down list box to&nbsp;show the entries&nbsp;from&nbsp;one of the table depending one wich one we use on the option button..</p><p>&nbsp;Is that possible?? </p><p>&nbsp;Please help! </p><p>thank you! </p>