Select Items from Multivalue list and autofill value into new table commo seperated

[Nancythomas]

Hi
I need help

I have two tables and two forms
Form 1 - is the master data entry form
Form 2 is a lookup list

In form1 - I have a memo field called category and a search button. The search button opens form2 that allows me to select multiple rows and load the selected items into Form1.

I just cannot get this to work. I cannot move multiple rows from form 2 to form1.

sample attached

 

[Minty]

You need to concatenate the values, however it's really not good practice to store these values in this way. It's perfectly acceptable for display purposes.

To keep your data sensibly you should store these values in a junction table with your Zookeeper Primary key and the Animal Primary key. That way you can easily interrogate either zoo keepers or animals to find out who is dealing with what.