Table design for packages RRS feed

  • Question

  • Dear Friends,

    I would like to create a table called product. My objective is to get list of packages available for each product in data grid view column while selecting each product. Each product may have different packages type (eg:- Nos, CTN, OTR etc). Some product may have two packages and some for 3 packages etc. Quantity in each packages also may be differ ( for eg:- for some CTN may contain 12 nos or in other case 8 nos etc). Prices for each packages also will be different that also need to show.  So kindly advise me how to design the table.. 

    Please see below example for more idea...

    Product name   :   Nestle milk |

    Rainbow milk

    packages  : CTN,OTR, NOs |

    CTN, NOs

    Price: 50,20,5 |


    (Remarks for your reference):CTN=10nos, OTR=4 nos   | CTN=8 Nos

    So please assist me...

    Thanks in advance

    • Edited by AliMonMK Tuesday, August 18, 2015 5:41 AM
    Tuesday, August 18, 2015 5:34 AM


All replies