Unanswered: Create Relational Field based on Condition (user selection)
In form 1 there are many fields: Field 1, Field 2, Field 3 etc. The problem is to create relational field on other form based on conditions. If user selects option 1 then a relational field should contain only Field 1 of Form 1. If user selects option 2 then a relational field should contain only Field 2 of Form 1 and so on...
So the basic problem here is to change columns of relational field based on choice. I wonder whether this would be possible...
Just a thought but would having 2 sheets (or more) on the second form with different views of related fields (same data source) which have sheet visibilty controlled by form 1 selection work for you? Will see how you go or wait for other suggestions before experimenting.