Welcome to SPN

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

Sign Up Now!

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
     

Share This Page