InfoPath Dev

 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 greatly appreciated!

thorny222:

available tables

 

What do you mean under "available"? available where and how?

 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    FeedID
                       MemberID
                       EmployeeID
                       SocialSecurityNumber
                       HICN
                       FirstName
                       MiddleName
                       LastName
                       DOB
                       Sex
                       RelationshipID

I assume that you are able to return both tables and fields data to the form, but you are looking the way to make the value in ddl changing dynamically according to what table is selected. Have you tried adding Filter Data to the repeating group in Ddl box property?