Returning values in a list from another table - strange results
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-22-2023 11:42 PM
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.