Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2013
    Posts
    15

    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...

  2. #2
    Join Date
    Sep 2011
    Location
    Australia
    Posts
    264
    Provided Answers: 2
    Hi
    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.
    Regards
    David

  3. #3
    Join Date
    Sep 2013
    Posts
    15
    Thanks for your suggestion...would try and reply back...

  4. #4
    Join Date
    Sep 2013
    Posts
    15
    It is a good work around if there are few fields. I tried it successfully.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •