Add multiple new 'things' from list

Need help Database
1

Hi there -

How can we add multiple things from a list in a database?

So for instance we have a database of all terms. One column has linked records to nutrients. When someone chooses apple, it has a nutrient column that is a ‘list’ of the ids of nutrients.

We want to add this list of ids of nutrients to a different nutrient table, but not only the nutrient but also it’s name from the list of names.

How can I set this up?

2

If I understand you correctly, your set up already sounds fine. The focus should be on getting the list to the other nutrient table which it appears you’re already doing. You should be able to pull up the names from the ID when displaying on the frontend.

If it helps, you can share a screenshot of the tables in question. Easier to see where you might be having a challenge