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,