Help

Link fields between base tables

762 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Peter_Goldstein
5 - Automation Enthusiast
5 - Automation Enthusiast

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

1 Reply 1
Zollie
10 - Mercury
10 - Mercury

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)