⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

Display data from the same table and save into another table



hkachhia
  • profile picture
  • Member

Posted 28 November 2020 - 09:41 AM

Hello 

 

I have one table Product, In this table below fields: 

 

Product code

productname

linked_prodct

etc..

 

 

So, here I want to display productname in add as link product and allow user to select multiple products 

 

For example in add, user going to add new product Apple, so user fill up all require information and at end of the add form, user can link multiple products from the dropdown such knife, fork etc . 

knife and fork already added in the product table. 

 

When user add new product apple all the information save in product table and link proudct id save as comma separated in linked_prodct field in the same table. 

 

So, Can you please help me how to achieve this?