InfoPath Dev

Using InfoPath 2010.  I have a form that I would like to hyperlinks go to different network folders based on a value in a textbox. I.E. - if ClientID = 1 then go to Z:\Medical\comp1         if ClientID = 2 then go to Z:\Medical\comp2 etc. Is this possible?  Thanks in advance for your time and help - it is greatly ...

Using 2010 I have a SQL view - SELECT c.ClientID, c.ClientName, p.ProjectID, v.VendorID, f.FeedID FROM  tbl_Clients c INNER JOIN       tbl_Projects p ON c.ClientID = p.ClientID INNER JOIN       tbl_Feeds f ON p.ProjectID = f.ProjectID INNER JOIN       tbl_Vendors v ON f.VendorID ...

 I only want the fields in the chosen table to appear in the drop-down .   Example -if tbl_Members is chosen in the Table drop-down you would only get the associated columns in that table table_name    column_name tbl_Members    ...

 I have a column - Table that lists the available tables.  I also have a column - Field.  What I want to do is if Table A is selected, in the Field column I want to list the available fields in the Field column.  If Table B is selected, list fields available from Table B, etc. Thanks in advance your time and help, it is ...

 I have a form that users fill out for work flow.  Within the InfoPath document, I have added hyperlinks to take the user to different drives where code and instructions reside.  When the user goes to save the form, I don't want to hyperlink to show.  Is this possible to do?  Thanks for any and all help, it is greatly ...