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.
Have you tried a multi select field and make the source "from another field"
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?
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?
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.
is it possible to have a multi select field that pulls from another field with a "add new choice" option?