Create a multi choice field from a relationship

  • 0
  • 2
  • Question
  • Updated 7 months ago
  • Answered
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. 
Photo of Ursula Ll

Ursula Ll

  • 1,678 Points 1k badge 2x thumb

Posted 2 years ago

  • 0
  • 2
Have you tried a multi select field and make the source "from another field"
Photo of Karen Packwood

Karen Packwood

  • 102 Points 100 badge 2x thumb
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?
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.,
Photo of Karen Packwood

Karen Packwood

  • 102 Points 100 badge 2x thumb
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

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.  
Photo of Howard Fu

Howard Fu

  • 324 Points 250 badge 2x thumb
is it possible to have a multi select field that pulls from another field with a "add new choice" option?