Multiple values in a column

Question

Hi I have a table named details. It has 3 fields vendorIDitemID and ItemName. I need to add more than one vendor for a particular item. For example: vendor ID:123 ItemID:1 ItemName:abc I need to store values in my table in the above model. Please help me.

Kailash Chandra Behera · Answer

Ranjith In your situation it's good to create a relational table to joint both vendor and item table. for Example like below table structure Item Vendor 1 1 2 1 1 2 1 3 you can display the details according your requirements