Create a multi choice field from a relationship

Question

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.

quickbasecoachd · Answer

Have you tried a multi select field and make the source "from another field

ursulall · Answer

OMG. I am dying. This is EXACTLY what I wanted

quickbasecoachd · Answer

:)

qbadmin11 · Answer

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?

quickbasecoachd · Answer

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

Forum Discussion

Create a multi choice field from a relationship

Related Content

Cross App Relationships

Limit Relationship Choices based on another field..

AI Smart Builder for Creating Apps and Streamlining Pipelines

create pipeline to create new records based on current record

Add button to create record in different app