Newbie Questions

Re: Dropdown values based on selection from another Dropdown

c4ntaloop — Tue, 11 Sep 2012 04:55:51 GMT

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?

Re: Dropdown values based on selection from another Dropdown

thorny222 — Mon, 10 Sep 2012 16:35:01 GMT

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

Re: Dropdown values based on selection from another Dropdown

Gennady Vanin (Геннадий Ванин, Новосибирск) — Mon, 10 Sep 2012 16:17:51 GMT

thorny222:
available tables

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

Dropdown values based on selection from another Dropdown

thorny222 — Thu, 06 Sep 2012 21:03:47 GMT

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!