Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1. Monthly (Recurring) Target: $300 :: Achieved: $95
      Become a Supporter    ::   Make a Contribution   

A challenge

Discussion in 'Information Technology' started by Tom, Jul 28, 2006.

Tags:
  1. Tom

    Tom
    Expand Collapse
    Guest

    Hi,

    I have a form bound to a table.

    on the form:
    TxtBox - Vendor
    ComboBox - Product
    TxtBox - Grade (A,B,C,D)

    I need that the grade value will be determined by the vendor and the
    product.

    i.e

    vendor=jackmarket and product=beef then automaticlly grade box will fill
    with A.

    vendor=jackmarket and product=lamb then grade box =b etc....

    I hope it`s possible.

    Thanks for the help and any suggestions.

    Tom
     
  2. Loading...


  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Tom wrote:
    > Hi,
    >
    > I have a form bound to a table.
    >
    > on the form:
    > TxtBox - Vendor
    > ComboBox - Product
    > TxtBox - Grade (A,B,C,D)
    >
    > I need that the grade value will be determined by the vendor and the
    > product.
    >
    > i.e
    >
    > vendor=jackmarket and product=beef then automaticlly grade box will
    > fill with A.
    >
    > vendor=jackmarket and product=lamb then grade box =b etc....
    >
    > I hope it`s possible.
    >
    > Thanks for the help and any suggestions.
    >
    > Tom



    There are several possible solutions. Are there only four possible
    results? Are the names in the table 100% consistent?

    Don't try to save the results, just display them.

    --
    Joseph Meehan

    Dia duit
     
  4. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    make a table for the combinations & lookup

    Pieter

    "Tom" <partner1973@yahoo.com> wrote in message
    news:%23RqExRffGHA.3652@TK2MSFTNGP02.phx.gbl...
    > Hi,
    >
    > I have a form bound to a table.
    >
    > on the form:
    > TxtBox - Vendor
    > ComboBox - Product
    > TxtBox - Grade (A,B,C,D)
    >
    > I need that the grade value will be determined by the vendor and the
    > product.
    >
    > i.e
    >
    > vendor=jackmarket and product=beef then automaticlly grade box will fill
    > with A.
    >
    > vendor=jackmarket and product=lamb then grade box =b etc....
    >
    > I hope it`s possible.
    >
    > Thanks for the help and any suggestions.
    >
    > Tom
    >
    >
     
  5. Tom

    Tom
    Expand Collapse
    Guest

    Thank you both.
    yes, there are only 4 options: A,B,C,D
    many vendors and many product.
    the code probably have to be in "afterUpdate" of the product combobox.
    All records has to be save for future review.
    examples will be most appreciated.

    Many Thanks,
    Tom

    "Pieter Wijnen"
    <it.isi.llegal.to.send.unsollicited.mail.wijnen.nospam.please@online.replace.with.norway>
    wrote in message news:%23gAy9WgfGHA.4776@TK2MSFTNGP05.phx.gbl...
    > make a table for the combinations & lookup
    >
    > Pieter
    >
    > "Tom" <partner1973@yahoo.com> wrote in message
    > news:%23RqExRffGHA.3652@TK2MSFTNGP02.phx.gbl...
    >> Hi,
    >>
    >> I have a form bound to a table.
    >>
    >> on the form:
    >> TxtBox - Vendor
    >> ComboBox - Product
    >> TxtBox - Grade (A,B,C,D)
    >>
    >> I need that the grade value will be determined by the vendor and the
    >> product.
    >>
    >> i.e
    >>
    >> vendor=jackmarket and product=beef then automaticlly grade box will fill
    >> with A.
    >>
    >> vendor=jackmarket and product=lamb then grade box =b etc....
    >>
    >> I hope it`s possible.
    >>
    >> Thanks for the help and any suggestions.
    >>
    >> Tom
    >>
    >>

    >
    >
     
  6. Tom

    Tom
    Expand Collapse
    Guest

    Another piece of information (hope it helps)
    All the vendors has the same products but with a different grade.

    Thanks again
    Tom
    "Tom" <partner1973@yahoo.com> wrote in message
    news:%23RqExRffGHA.3652@TK2MSFTNGP02.phx.gbl...
    > Hi,
    >
    > I have a form bound to a table.
    >
    > on the form:
    > TxtBox - Vendor
    > ComboBox - Product
    > TxtBox - Grade (A,B,C,D)
    >
    > I need that the grade value will be determined by the vendor and the
    > product.
    >
    > i.e
    >
    > vendor=jackmarket and product=beef then automaticlly grade box will fill
    > with A.
    >
    > vendor=jackmarket and product=lamb then grade box =b etc....
    >
    > I hope it`s possible.
    >
    > Thanks for the help and any suggestions.
    >
    > Tom
    >
    >
     
  7. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Tom wrote:
    > Thank you both.
    > yes, there are only 4 options: A,B,C,D
    > many vendors and many product.
    > the code probably have to be in "afterUpdate" of the product combobox.
    > All records has to be save for future review.
    > examples will be most appreciated.
    >
    > Many Thanks,
    > Tom
    >


    I am having a difficult time trying to get the tables and data straight
    in my mind. Could you provide the table structures?

    --
    Joseph Meehan

    Dia duit
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page