Auto-populate multiselect lookup field from another multiselect field

Auto-populate multiselect lookup field from another multiselect field

Hi, I want to auto-populate a multi-select lookup field with the data from another multi-select lookup field.

Form 1 "Item"
"Name" (text field)
"type" (multi-select lookup)


Form 2
Multi-select field "Item Name" (this lets me pull up any of the form 1 entries)
Multi-select field "type" --- this is the one I want to auto-populate from whatever was on the form 1 entry.

For instance if form 1 entry was:
Name: Pencils
Type: Office supplies

Then when I select "pencils" entry in form 2, I want it to be like this:
Item name: Pencils
Type: "office supplies" (pulled in from the form 1 entry).

How can I do this?

Thanks in advance,