Discussions

Expand all | Collapse all

Create a multi choice field from a relationship

  • 1.  Create a multi choice field from a relationship

    Posted 08-30-2017 16:56
    Hi All.
    I need to create a multi choice field in table A that is pulling in all records from table B, and the user can choose from the records to be included in the field. Is this possible? If not, what is a good workaround for this functionality? 
    I need to be able to see if a record from table B has any other secondary relationship to table A.
    My initial thought was to create a sub-table for Table B, which was a self relationship, to pull in any other Table B records that were related to that record. This would then be pulled out and concatenated in the field of Table A. However, that is a lot of code, and API calls, and I would rather see if there is a different option. 


  • 2.  RE: Create a multi choice field from a relationship

    Posted 08-30-2017 18:32
    Have you tried a multi select field and make the source "from another field


  • 3.  RE: Create a multi choice field from a relationship

    Posted 08-30-2017 18:35
    OMG. I am dying. This is EXACTLY what I wanted


  • 4.  RE: Create a multi choice field from a relationship

    Posted 08-30-2017 18:39
    :)


  • 5.  RE: Create a multi choice field from a relationship

    Posted 12-20-2018 17:09
    What if I don't want all records from Table B but only those, as text-multiple choice list, which the field Status=In progress?


  • 6.  RE: Create a multi choice field from a relationship

    Posted 12-20-2018 17:13
    If you just want to select 1 choice on a drop down list then you can make a relationship  and use a report on he form to limit the choices to just Status = In progress.  But that technique will not work for a multi select field type when you are choosing multiple selections n that one field.,


  • 7.  RE: Create a multi choice field from a relationship

    Posted 12-20-2018 19:33
    hum..ok

    I need a multiple-choice field (Activity category) where choices are depending of the status of the program selected. 
    Can I set up a formula into the Text-Multiple Choice instead of a "hard" list?

    Thanks



  • 8.  RE: Create a multi choice field from a relationship

    Posted 12-20-2018 19:35
    See my post above

    If you just want to select 1 choice on a drop down list then you can make a relationship  and use a report on the form to limit the choices to just Status = In progress.  


  • 9.  RE: Create a multi choice field from a relationship

    Posted 12-21-2018 01:07
    is it possible to have a multi select field that pulls from another field with a "add new choice" option?