I'm building an inventory system where i have the Products table with:
PK ID - Name - Category
I need to assign Products to existing products in this table. Maybe this sounds a little bit confusing so i designed an example:
This is the table i currently have
This is what i want to achieve but i don't know how.
My questions are, how can i edit my Products model for a correct reference of these items? I should use varchar, or a list, or reference items by it's id?
If it's via String, how can i concatenate the multiple rows into that one?