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

Posted Apr 11, 2014, 8:39 AM
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,