it takes 3 items to make one item

Discussion in 'MySQL' started by xbat, Jun 4, 2011.

0
  1. #1
    ok I have a stocklist of 2000 parts.. but by the time they go out the door it takes 4 parts at least.. I was wondering if there is a simple way where the select the part at the door and it automatically detucts the other parts.. I am working with php and mysql... I want make it so the system automattically minus's the 4 parts when the one item number is selected.

    :cool:
     
    xbat, Jun 4, 2011 IP
  2. Cucumba123

    Cucumba123 Well-Known Member

    Messages:
    1,403
    Likes Received:
    34
    Best Answers:
    3
    Trophy Points:
    150
    #2
    Can you paste your existing code and what you have tried to do so far? That way we will be able to assist you in the place where you are stuck.
     
    Cucumba123, Jun 4, 2011 IP
  3. xbat

    xbat Well-Known Member

    Messages:
    326
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    105
    #3
    I haven't tried anything.. I was just putting thoughts together.. Is something like this even possible.. or is there a easy way to go about it?
     
    xbat, Jun 4, 2011 IP
  4. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #4
    Is there any relation between the item numbers? I mean how the system will know part number say 12345 and 23223 are same products/parts.
     
    mwasif, Jun 4, 2011 IP
  5. xbat

    xbat Well-Known Member

    Messages:
    326
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    105
    #5
    If that is something i have to do.. then I will do it.. what would you recommend?
     
    xbat, Jun 5, 2011 IP