Link fields between base tables

[Peter_Goldstein]

I have a base with two tables.

• A is a list of projects
• B is a list of tasks for projects from A
  I would like to populate the available items in a muliti-select field in table B with existing items from a muliti-select field in table A.

Thanks for any assistance!
Peter

[Zollie]

Hey again Peter. I don’t believe it’s possible to dynamically populate the available options in a multi-select - or even ensure two multi-select fields have matching values.

It’s not ideal, but you could try using linked records rather than a multi-select. Something like this:

Projects
Multi-Select (linked record)

Tasks
Multi-Select (linked record)

Multi-Select Values
Value Name (single line text)