relate tables - please help

Discussion in 'Access VBA Modules' started by Lasitha, May 25, 2012.

  1. Lasitha

    Lasitha Guest

    METHOD TABLE
    =======
    CTC
    ORT
    ---------------------------



    TEA GRADES TABLE
    ================
    METHOD TEA_GRADES
    CTC BP1
    CTC PF1
    CTC D
    CTC D1
    ORT BOP
    ORT FF
    ORT OPA
    ORT PEKOE
    ---------------------------------------

    There is two tables called tea method table & tea grades table....
    now I need to create a new table called INVOICE TABLE

    INVOICE METHOD GRADE QUINTITY
    (UNIQUE) (from (from (kg)
    method grade (enter
    table) table) manually)

    001 CTC D1 2000

    002 CTC PF1 1000

    003 ORT PEKOE 1500

    004 ORT PF1 1750

    *problem with last row grade


    here I have lookup METHOD & GRADE from above mentioned tables but in
    this grade column last row PF1 belongs to CTC grades. that is not
    correct.... I need to get only relevant grades when I select CTC or
    ORT from METHOD column....
    please help me... thanks in advance any help....
     
    Lasitha, May 25, 2012
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.