Jump to content

swatisonee

Members
  • Content count

    253
  • Joined

  • Last visited

Community Reputation

0 Neutral

About swatisonee

  • Rank
    Advanced Member

Profile Information

  • Gender
    Not Telling
  1. swatisonee

    Multiple data in a single record

    Oh thanks ! Where I get stuck is at the product_quote stage. But I am going to study your solution now.
  2. swatisonee

    Multiple data in a single record

    Hi. I have a product database w/ tables each for product series, model, sub-model and optionals. One item in each of these makes up one product. So Series K, Model 7, sub-model 2, optional 3 will be a product called K 7/2-3 .The permutations and combinations of these are all possible products. In the same db, I have a quotations table. Each quotation has a unique id / record. A quotation can include any number of products : it can have K 7/2-3, KA 561/1-2 , FPN 311/2-1 or it can only have KA 561/1-2 etc. Now I am stuck. Don't know how to a. structure the quotations table b. create a MySQL select so that one statement can make multiple selections . I thought of using a checkbox but that doesn't work either since the series/model/sub model/optionals must chosen sequentially. Any ideas I can follow thru ? Many thanks Swati
×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.