Returning values in a list from another table - strange results

c1avzz
Giga Contributor

I am building an app (first one!) and I am trying to allow a user to enter more than one value in a form, but the list is from another table. 

 

So I have table 1 (linked to my form) returning values from another table for a list.

 

e.g. Table 1 - new entry called shopping list, Table 2 - already got entries like apples, pears etc

So I want to create a new entry in Table 1 that contains multiple values from Table 2 

 

This appears to work on the form but when I save and look back at the table the first entry says apples but the other items are all remove and replaced with a single entry that is something like c832f17 or on another table 1 entry it is replace with a6aa1db.

 

Doing something wrong but not an idea what!!! Any ideas pointers.

0 REPLIES 0